How can I write to text file

[blue]

Hi, All:
Can I output to text file on Test window like Oracle D2000's TEXT_IO.PUT_LINE?
or
Can I output to grid data format like Sql window query result grid at Test window?
Thanks!

 

[Marco Kalter]

Can I output to text file on Test window like Oracle D2000's TEXT_IO.PUT_LINE?

No, but you can write to the output buffer by using the dbms_output.put_line function. The results will be displayed on the "DBMS Output" tab page.

Can I output to grid data format like Sql window query result grid at Test window?

Only if the results are in the form of a cursor variable.