Re: Query with contents of text file.
- From: Brian Peasland <oracle_dba@xxxxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Apr 2006 16:50:22 GMT
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@xxxxxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Query with contents of text file.
- From: Mark D Powell
- Re: Query with contents of text file.
- References:
- Query with contents of text file.
- From: Muggle
- Query with contents of text file.
- Prev by Date: Re: Strange bug in 10.2.0 involving merging rows from one table into another
- Next by Date: Re: numeric check
- Previous by thread: Query with contents of text file.
- Next by thread: Re: Query with contents of text file.
- Index(es):
Relevant Pages
|
|
