Wednesday, May 2, 2018

How to take .lst file


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

No comments:

Post a Comment

View sql statement from oaf page

Below are the detailed steps: 1) Update the following Profile Option Values to Yes at User level. • FND: Diagnostics • Personalize Self...