SQLTeam.com | Weblogs | Forums

Query more than 1000 account in a where statement


#1

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?


#2

This is a Microsoft SQL Server forum. You might get better/faster responses if you post the question to to an Oracle forum.