Newbie PL/SQL question

From: mobiGeek <greg_fenton_at_yahoo.com>
Date: 17 Feb 2003 06:56:12 -0800
Message-ID: <ea61f029.0302170656.6c1d587a@posting.google.com>

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

    ORDER BY col2, col3 DESC

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