Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Query with contents of text file.

Re: Query with contents of text file.

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Mon, 24 Apr 2006 16:50:22 GMT
Message-ID: <Iy8K42.K4u@igsrsparc2.er.usgs.gov>


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
Received on Mon Apr 24 2006 - 11:50:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US