PL/SQL (MOSC)

MOSC Banner

spool

in PL/SQL (MOSC) 2 commentsAnswered ✓

Hi,

On 19c , I run my query and I spool the result:

spool myfil.txt

select count(*) from mytable;

spool off

But I want to have a line just at the beginning of my spool file , like this:

This is the result:

How to do that easily (without dbms.output.... or ......).

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center