Re: Query with contents of text file.

From: gazzag <gareth_at_jamms.org>
Date: 26 Apr 2006 02:35:39 -0700
Message-ID: <1146044139.781002.128380@u72g2000cwu.googlegroups.com>

Harry331 wrote:
> A little shell script will do.
> Suppose you have a text file 'id.txt' containing the id's.
>
> $ seq 100 110 > id.txt
> $ cat id.txt

<--------------------------------------------------sniiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiip--------------------------------->

>Then plug your query to sqlplus.
>
> $ sqlplus user/password_at_whaever @myquery.sql

A clasic, convoluted, over-complicated Unix solution. Nice. There may be many ways to skin the proverbial cat in a Unix environment, but you're still far better off with the right tool for the right job.

As has already been mentioned in this thread, I'd recommend external tables. More appropriate, more intuitive, more readable. Received on Wed Apr 26 2006 - 04:35:39 CDT