Re: Query with contents of text file.

You can use SQL*Loader to load the contents of the text file into the Oracle database. From there, you can issue your query against that table.

Another option is to use External Tables to interface with the text file directly using SQL statements, just as if the data were in an actual table. There are a few advantages to this option over SQL*Loader. One, if you will be replacing this file's contents on a regular basis, just overwrite the file and the External Table will access the new data. Two, You do not allocate space for the file's contents inside the database like you would if you loaded the file's contents with SQL*Loader.

Both options are discussed fully in the Oracle documentation.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown