execute the queries that do the record count in sqlplus
Date: Sat, 12 Jul 2008 08:27:44 -0700 (PDT)
I have a script test1.sql that has the queries that do the record count in the tables.
When I run the script in SQLPLUS using @C:\test1.sql, I only got the result, but I want to print the queries too so that I know which queries corresponding to which result. Any ideas how? thanks!!
SELECT COUNT(*) FROM T1; SELECT COUNT(*) FROM T2; SELECT COUNT(*) FROM T3; SELECT COUNT(*) FROM T4; SELECT COUNT(*) FROM T5;
SPOOL OFF test1.txt
131 Received on Sat Jul 12 2008 - 10:27:44 CDT