Skip to Main Content
Forums

SQL & PL/SQL

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!

DYNAMICALLY CHANGE SPOOL FILE NAME

810582Jan 5 2011 — edited Jan 7 2011
Hi,
Oracle Version: 10g.
M/c: Windows XP.
Environment: SQL*PLUS.

Select empname from emp where empno=1;

now whatever comes as empname should be the spool files name.(EX: SPOOL JOHN.TXT)

Is it possible?

Is there any possibilty to do it with the help of define statement in SQL*PLUS.

Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2011
Added on Jan 5 2011
8 comments
9,178 views