Re: Some questions

From: Richard Woods <rawoods_at_concentric.net>
Date: 17 Jun 1998 19:20:42 EDT
Message-ID: <35884FAF.47FE7187@concentric.net>

Yes to both. Use the pseudo-column rownum in your where contraint to limit the number of returns rows, i.e., where rownum < 1000.

Two date datatypes can be subtracted for the number of days between, for example.

calberto_at_boreal.com.br wrote:

> 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 - 18:20:42 CDT