Monday 29 December 2014

How to take .lst file in oracle


LST stands for Spool file (Oracle)

Log in SQL Plus



Type :-

spool echo_off_output_2.lst
SQL>@E:\xxxxx.sql
spool off

spool echo_off_output_2.lst
@D:\Suguna\MasTec\Incidents\220743\Change_datafix\afchrchk.sql
spool off

1 comment:

  1. Hi all, Oracle technical and fusion cloud SCM online classes, if you are interested please whatsapp to this number +91 7382582893, thank you.

    ReplyDelete