Initializing a variable in sqlplus [message #10338] |
Thu, 15 January 2004 05:36 |
Alexander
Messages: 109 Registered: May 2000
|
Senior Member |
|
|
I would like to initialize a variable (var1) but am not sure how to do it....
Here is the script I was trying to write. What am I doing wrong.
set var1 = 'c:inetpubwwwrootdata'
set var2 = 'blahblahblah'
spool counts.sql
select 'select mydir as ' || var1 || ' ' || var2 || ' from ' || object_name
from user_objects
where object_type in ( 'TABLE' )
order by object_name;
/
|
|
|
|