sqlplus and sql devloper have a limit of 1000 records. I need to query 140k account from a single table. How do i do that ? how do i also use a list of all accounts from a file to use in a batch sql job to lookup the values?
where acct IN (
......etc up to 140k records ! Is there away to reads the accnts from a file into this sql?