Home » RDBMS Server » Server Administration » How can i make a parametarize filename in spool?
How can i make a parametarize filename in spool? [message #375112] Fri, 27 July 2001 04:24 Go to next message
Norvin
Messages: 22
Registered: July 2001
Junior Member
We have the command: spool filename[[.lst]]
How can i make that filename a variable filename?

Report message to a moderator

Re: How can i make a parametarize filename in spool? [message #375119 is a reply to message #375112] Fri, 27 July 2001 16:00 Go to previous message
Cindy
Messages: 88
Registered: November 1999
Member
Try this:

SQL> @c_test.sql
Enter filename: testing.list

'H
--
HI
--------------------------------------------
SQL> host more testing.list

'H
--
HI

-----------------------------------------------
SQL> host more c_test.sql
SET VERIFY OFF
ACCEPT v_spoolnm PROMPT 'Enter filename: '
spool v_spoolnm

select 'HI' from dual

/
SPOOL OFF
SET VERIFY ON

Report message to a moderator

Previous Topic: Re: Duplicate values only once
Next Topic: oracle script
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:06:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.