select variable [message #36170] |
Thu, 08 November 2001 08:23 |
confuse
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
how can we select value of variable in place of column name in select statement
----------------------------------------------------------------------
|
|
|
Re: select variable [message #36181 is a reply to message #36170] |
Thu, 08 November 2001 13:20 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
declare
n1 number(10):=9;
begin
select n1 into n1 from some_table where rownum<2;
dbms_output.put_line(n1);
end;
-- n1 is not column name, its variable
----------------------------------------------------------------------
|
|
|