Thursday, February 23, 2006

Redirecting SQLplus output to text file

You could try spooling the output, but here is an easier option:

test.sql should contain your sql statements.

sqlplus -s scott/tiger <> test.lst
@test
exit
STOP

No comments: