thanx for the overwhelming support it is working now with spooler setiings now i want to go one more step in advance i have a email id creation script for creating emailid for our org now iam manully prompting & keying the first name & lastname via my script now i want to get firstname & lastname from my erp oracle databse with the erpno as input and store the firstname and lastname from the database to 2 different variable and create my email id with the output from the query of output sql script is ready with me but how to assign the values of the output to avaraiable and redirectiing the values to my script as soon as iam out of the sql prompt any idea ? regards ashok
--- On Wed, 20/5/09, Nadeem M. Khan <[email protected]> wrote: From: Nadeem M. Khan <[email protected]> Subject: Re: [LinuxVadaPav] How to redirect oracle sql query output to a text file To: [email protected] Date: Wednesday, 20 May, 2009, 7:53 PM On Wed, May 20, 2009 at 4:35 PM, ashok abraham <ashok...@yahoo. com> wrote: > > > > Dear all > > How to redirect oracle sql query output to a text file > instead to console SQL> spool /tmp/output. txt SQL> select instance_name, status from v$instance; SQL> spool off SQL> exit $ cat /tmp/ouput.txt Regards, NMK Bollywood news, movie reviews, film trailers and more! Go to http://in.movies.yahoo.com/ [Non-text portions of this message have been removed]
