These days I am checking whether amount is correctly upload into one of our table its located in oracle database below query used to check this
Select * from Amount_Paiad where CusID IN ('34343','34343','090094')
There is no issue in query.Problem is how many values I can enter to IN Statement.There is more than 5000records.
Problem is once I enter 5000 records into sql statement ,sql developer and sql navigator generate error message saying ' Only 1000 records can insert to IN statement.
I only have read access for database tables.Please let me is there more better way to do this,is there way to increase the values(More than 1000) used IN Statement.