Home » SQL & PL/SQL » SQL & PL/SQL » Initializing a variable in sqlplus
Initializing a variable in sqlplus [message #10338] Thu, 15 January 2004 05:36 Go to next message
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;
/
Re: Initializing a variable in sqlplus [message #10341 is a reply to message #10338] Thu, 15 January 2004 08:39 Go to previous message
Alexander
Messages: 109
Registered: May 2000
Senior Member
Never mind, I figured it out.
Previous Topic: Currect working database user
Next Topic: Urgent -Clob Error
Goto Forum:
  


Current Time: Thu Mar 28 18:54:31 CDT 2024