Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to redirect the results of an SQL query to a text file?

WilhelmJul 25 2007 — edited Jul 25 2007
To see the underlying script of a procedure or function i query
SELECT text FROM dba_source WHERE name=<procedure/function_name>; .
But if the procedure's code is too large, it won't fit in the window. I telnet from Windows XP Dos. I tried increasing the Width and Height of both Screen Buffer size and Window Size of XP DOS(Properties). It didn't work. Any suggestions?

Is there anyway i could save the result of this query ie. the underlying script of the procedure to a text file?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2007
Added on Jul 25 2007
#general-database-discussions
5 comments
4,094 views