I work on postgreSQL which is very similar to SQL. here i used to do this:à Postgres> \o <filename>; à Postgres> <Fire the query> Check the o/p in the spool file generated I am not sure but may be it work on oracle? --- On Thu, 21/5/09, siva dass <[email protected]> wrote:
From: siva dass <[email protected]> Subject: Re: [Linux_Mantra] How to redirect oracle sql query output to a text file To: [email protected] Date: Thursday, 21 May, 2009, 4:01 PM Try select * from table into outfile '/tmp/test.txt' ; Sivadass.M --- On Wed, 20/5/09, ashok abraham <ashok...@yahoo. com> wrote: From: ashok abraham <ashok...@yahoo. com> Subject: [Linux_Mantra] How to redirect oracle sql query output to a text file To: linuxvadapav@ yahoogroups. com, Linux_Mantra@ yahoogroups. com 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] 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]
