Substitution variables from a table

[SteveCulshaw]

Is there anyway to get a value from a select into a variable ?
e.g. define report_user select user from dual
so I can do some work later in the SQL script Cheers,
Steve C.

 

[THoey]

Don't you use the SELECT something INTO variablename ... format? I haven't used it in a while, but I think it is something like that. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[SteveCulshaw]

In plain SQL it doesn't work, the only way I've found is to use PL/SQL

DECLARE
report_user VARCHAR2(200);
BEGIN
SELECT USER
INTO report_user
FROM dual;
DBMS_OUTPUT.put_line(' User is : ' || report_user);
END;
/ Cheers,
Steve C.

 

[stefanhei]

You can set user-variables via new_value:
define report_user=''
column rep_usr noprint new_value report_user
select user rep_usr from dual;

You can use the variable in tti without the define-part it.

Stefan