Is it possible for spooling with my comments?
dbms_output.put_line ?
I want to spool more than one select statement. Before each select statement i need to give some comment. Is it possible spool with this given comment?
~Saravanan
Hi Saravanan,
Unfortunately, SQL Nav doesn’t support spooling with comment. a work around for your problem is using PL/SQL block to print out the comments. The spool window will capture this output hence giving you indications of the statement that you’re executing. It’s a tacky way to solve the problem but right now that’s all i can think of.
Hope this helps
Gwen