Re: HELP!!! complex Sql command using text file

I think your best bet would be to use the utl_file package to read the file line by line into a temp table and then do your select from there.

In this way you could do the whole thing by executing one PL/SQL stored procedure.

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Chris Reddy wrote in message <7dtrc9$3ig$2_at_news-2.news.gte.net>...


>Hi everyone,

>

>My customer has provided me with a text file that contains account numbers

>all in one column.

>

>The database table I have contains account numbers as well as additional

>information I need to retrieve.

>

>How do I use the text file as a variable so that only the account numbers

>listed are retrieved from the database table.  I know how to retrieve all

 of


>the account numbers from the table, but then I have to run a separate

>comparison to the text file to generate a report of only the account

 numbers


>that my customer is looking for.

>

>Can someone please help me with the the sql commands.

>

>I appreciate any help, you can e-mail me _at_ iiidana_at_ix.netcom.com

>or post to the group.

>

>Thanks in advance,

>

>Chris Reddy

>

>

>

>

>

>

>