RE: sql query read from text file

How about this simple script: # Script to check processing the_pids=`cat a.txt | awk '{printf("%s,",$1)}' | sed 's/,$//'` sqlplus /

Re: sql query read from text file

On Jun 19, 2001 at 11:15:46PM, Vladimir Begun wrote: > On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote: > > Hi > > If i have one file a.txt and I want to put that content in where clause of > > sql statement then how can I do it. > > Example : > > a.txt content > > 98989 > > 67676 > > 898989 > >

Re: sql query read from text file

On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote: > Hi > If i have one file a.txt and I want to put that content in where clause of > sql statement then how can I do it. > Example : > a.txt content > 98989 > 67676 > 898989 > Select x,y,z from abc > where x in (98989,67676,898989) > / create file

sql query read from text file

Hi If i have one file a.txt and I want to put that content in where clause of sql statement then how can I do it. Example : a.txt content 98989 67676 898989 Select x,y,z from abc where x in (98989,67676,898989) / Actuall I want to do it in unix.I want to know the first 2 or 3 high CPU using proc