OraFAQ Forum: Server Administration » How to Store a query result in a text file?

Home » RDBMS Server » Server Administration » How to Store a query result in a text file?

Tue, 31 October 2000 01:03

Pravin Deshmukh
Messages: 8
Registered: October 2000

Junior Member

Hi everybody,
I am a beginner,I need to store query result that is executed in sql* plus,in a text file.
Thank you!!

Tue, 31 October 2000 03:19

Cliff
Messages: 6
Registered: October 2000

Junior Member

1) at the beginning of the query, add line: spool c:\temp\result.txt.
2) at the end of the query, add: "spool off"

Wed, 01 November 2000 02:27

Pravin Deshmukh
Messages: 8
Registered: October 2000

Junior Member

Yes,it's working.
Thanks a lot for your help.

Previous Topic:	ora00604 error
Next Topic:	How to delete the rows from a table with rownum is a multiple of 3

Goto Forum:

]

Current Time: Wed May 01 18:38:02 CDT 2024