SQL & PL/SQL

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 unload data to text file with plsql ?

411499Apr 27 2004 — edited May 7 2004

Hi all.

I want use plsql to execute a select statement and let the result of select to a text file.

in store procedure of informix , my code is follow :

UNLOAD TO '/user/informix/ud_machine/ud_machine.txt'
SELECT * FROM phm_udmachine ORDER BY bed_no , med_code

in plsql , what is the syntax to execute ?

STRONG LIN.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2004

Added on Apr 27 2004

5 comments

333 views