SQLTeam.com | Weblogs | Forums

Query more than 1000 account in a where statement


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?
from sv
where acct IN (

......etc up to 140k records ! Is there away to reads the accnts from a file into this sql?


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