Spooled SQL script from DYNAMIC SQL should only have the output of the DYNAMIC SQL and nothing else
My code is as follows:
set heading off
SELECT 'AUDIT INSERT, UPDATE, DELETE on '||tablename||' ;
ORDER BY tablename;
I run the above dynamic SQL statement in SQL*PLus and spool the output to a SQL script yy.sql.
When I open the SQL script, it has the query at the top, then the output of the dynamic statement, number of rows retrieved, and spool off.
I need the following:
When the above SQL script is created, it should only have the output of the dynamic SQL statement. It should not have the query at the top, and number of rows retrieved, and spool off after the output.
How do I do this in SQL*Plus?
This is important and urgent. I will give a 1000 points to anyone who gives me the correct solution.