Home » SQL & PL/SQL » SQL & PL/SQL » select variable
select variable [message #36170] Thu, 08 November 2001 08:23 Go to next message
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
n1 number(10):=9;
select n1 into n1 from some_table where rownum<2;

-- 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