Re: Some questions

Don't know about your first question, but for the dates - yes, Oracle can give you the number of days between dates (make sure you are using DATE datatypes in your columns you are using or a TO_DATE function on a non-date datatype first):

select
to_date('06/13/1998','MM/DD/YYYY')-to_date('06/03/1998','MM/DD/YYYY') "date_diff"
from dual;

date_diff

       10

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Richard Woods <rawoods_at_concentric.net> wrote in article <35884FAF.47FE7187_at_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
Received on Thu Jun 18 1998 - 10:47:08 CDT