Hello *.Tomazetti;
To get a select to return just the first
n number of matching rows add ROWNUM =
n to your WHERE clause; (or just simply grabbing the first record in a FETCH is just as efficient.)
Is there some reason you are using a cartesian join in your select?
>hello *.*
>
>I need to select just the first record from a SELECT STATMENT, like this:
>
>
>SELECT customer.OID, reserv.OID
> from customer, reserv
> where customer.OID = 1234
> into cursor test
>
>Ok, this SELECT may return many records, but I want select just the first record. How can I do it ?
>
>I´ve tried use the SAMPLE STATMENT, but We can´t use this statment with 2 tables or more.
>
>Please, help me!
>
>Thank you ALL
George