Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to SPOOL &_something like in SQL*Plus

BrunoVromanOct 1 2014 — edited Oct 1 2014

Hello,

in SQL*Plus I can generate the name of a spool file with something like

COLUMN logname NOPRINT NEW_VALUE _logname

SELECT TO_CHAR( sysdate, 'YYYY_MM_DD_HH24MISS' ) || '.log' logname FROM dual;

SPOOL &_logname

I can't make this work in SQL Developer... (SQL Developer prompts me for "_LOGNAME?")

Could anybody help me?

Thanks in advance,

Bruno Vroman.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2014
Added on Oct 1 2014
#sql-developer
4 comments
1,511 views