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?
select
acct
,NEW_CURRENT_SPID
from sv
where acct IN (
"2012050606",
"2012060223",
......etc up to 140k records ! Is there away to reads the accnts from a file into this sql?