Use the new_value feature:
var myvar varchar2(30)
exec myvar := 'Hello'
col myvar new_value myvar
select :myvar myvar
from dual
/
select '&myvar'
from dual
/
|
Results 1 to 6 of 6
Threaded View
|
Click Here to Expand Forum to Full Width |