Spool with Comments

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