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. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete