Some questions

From: <calberto_at_boreal.com.br>
Date: Wed, 17 Jun 1998 21:58:56 GMT
Message-ID: <6m9e6v$o7q$1@nnrp1.dejanews.com>

Hi all!!

Can I set in Oracle, inside a PL/SQL procedure, the number of rows returned by a query like I set in Sybase(SET ROWCOUNT 1)? I know I can test this variable (SQL%ROWCOUNT). Another question : Oracle has a date function that returns the number of days between two given dates?

Thanks in advanced,

Carlos

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 16:58:56 CDT