Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Newbie PL/SQL question
I am new to PL/SQL. I am trying to get the first row from a SELECT
result set, but am not sure how to go about it.
In ASA, I can do:
SELECT FIRST col1
INTO @my_variable FROM table1
This will get the value of "col1" from the FIRST row in the result set.
How can I go about this in PL/SQL ?
Thanks in advance,
mobiGeek.
Received on Mon Feb 17 2003 - 08:56:12 CST