| 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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
