Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ??? What is the substitution for the function FIRST in ORACLE????

Re: ??? What is the substitution for the function FIRST in ORACLE????

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 26 Feb 2005 20:08:11 GMT
Message-ID: <Xns96097B75DF4CCSunnySD@68.6.19.6>


"G-Shock" <g-shock_at_g-shock.com> wrote in news:4220b725$1_at_news.012.net.il:

> Hi There,
> MS-Access hes FIRST() function but Oracle ): hasn't.
>

In a real RDBMS there is no such thing as a FIRST or LAST record of a table FIRST & LAST are based upon some order being placed on 1 or more columns. A table is just a collection of records without any inherent order. Received on Sat Feb 26 2005 - 14:08:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US