Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Hi @Bhaskar Konar Thank you. I am looking for below confirmation on the limitation. "Oracle allows up to 1,000 IN list values in a SQL statement."

in How to Fetch more than 1000 records with BIP or OTBI report Comment by Sudheer YN Mar 22, 2023 1:57PM
Hi @Bhaskar Konar , So we have to restrict it with Filter, but cannot use more than 1000 values in the conditions right. I mainly want to know its possible or not. I understand we can do it with additional filters or restrict with additional parameters.

in How to Fetch more than 1000 records with BIP or OTBI report Comment by Sudheer YN Mar 22, 2023 12:06PM