Print SQL statements of script run on Oracle DB with sqlplus [duplicate]

Question

I'm using sqlplus to run a complex sql script and I'd like to be able to see the actual sql statement being run at the time along with the rest of the output. I've tried setting options such as 'set serveroutput' but I can't find the option that causes the sql being run to be written to stdout with the result.

anudeepks · Accepted Answer · 2015-05-01 03:46:59Z

0

SQL> set echo on
SQL> @C:\AKS\aks_scripts\test.sql
SQL>
SQL>
SQL> select count(*) from user_objects;

  COUNT(*)
----------
       110

SQL>
SQL> select count(*) from emp;

  COUNT(*)
----------
        14

SQL>
SQL> select count(*) from testemp2;

  COUNT(*)
----------
    851968

answered May 1, 2015 at 3:46

anudeepks

1,1321 gold badge14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Print SQL statements of script run on Oracle DB with sqlplus [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related