Try select * from table into outfile '/tmp/test.txt';
Sivadass.M --- On Wed, 20/5/09, ashok abraham <[email protected]> wrote: From: ashok abraham <[email protected]> Subject: [Linux_Mantra] How to redirect oracle sql query output to a text file To: [email protected], [email protected] Date: Wednesday, 20 May, 2009, 6:05 PM Dear all How to redirect oracle sql query output to a text file instead to console Regards ashok Explore and discover exciting holidays and getaways with Yahoo! India Travel http://in.travel. yahoo.com/ Explore and discover exciting holidays and getaways with Yahoo! India Travel http://in.travel.yahoo.com/ [Non-text portions of this message have been removed]
