Home » SQL & PL/SQL » SQL & PL/SQL » select variable
select variable [message #36170] Thu, 08 November 2001 08:23 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: doubt in pl\sql wrapping
Next Topic: Re: Study Questions II
Goto Forum:
  


Current Time: Mon May 20 03:59:37 CDT 2024