Re: Getting first/last record

Steve

Not sure where you got the software from, since it's usually shipped with the documentation online, but in any case, I would suggest two things:

1. Call the people you got the software from and ask for the documentation, or call Support and ask them for it. As far as I know, it's not something you need to pay extra for unless you want hard copy.
2. While you're waiting for that, get yourself an account on http://technet.oracle.com (it's free). All the doco is available online there for you.

HTH. Pete

STEVE wrote:

> Hi,
> thanks for all the help.
> I don't have an oracle ref manual, the oracle was supplied as part of a
> package with server software, but they did not include the manuals!!
> ether paper or on CD.
> WHAT'S THE POINT ORACLE!!
>
> steve
>
> Kevin A Lewis <KevinALewis_at_Hotmail.com> wrote:
>
> > does
> >
> > select to_char(sysdate,'HH24:MI:SS') from dual
> >
> > Help at all - See your "SQL Language Reference Manual" for more details
> >
> > --
> > Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> > <KevinALewis_at_HotMail.com>
> >
> > The views expressed herein by the author of this document
> > are not necessarily those of BOCM PAULS Ltd.
> > STEVE <spectre_at_hkstar.com> wrote in message
> > news:1duzlc6.l8llj89qdonwN@[201.1.1.73]...
> > > HI,
> > > Thanks for your Quick reply, the only thing that wories me is that the
> > > time does not actually show up, is it to second resolution?
> > > even if i do a "SELECT SYSDATE FROM DUAL;" it does not show the time.
> > > my oracle 8 bible says time is available , but does not go into it.
> > >
> > > All you book writers pay attention.
> > >
> > > steve
> > >
> > >
> > > Brian Peasland <peasland_at_email.msn.com> wrote:
> > >
> > > > >Being a bit of a newbee, to oracle8 can anybody help with the
> > following.
> > > > >1.How to get the first record in an ordered table
> > > > >2 How to get the last record in an ordered table.
> > > > >the order being on date then time.
> > > >
> > > >
> > > > The Oracle DATE format stores both the date and the time in one field.
> > So
> > > > you can just query the date field. Assuming the table is named 'TABLEX'
> > and
> > > > the date field is labelled 'COLX', try this:
> > > >
> > > > SELECT min(COLX), max(COLX) from TABLEX;
> > > >
> > > > Hope that helps,
> > > > Brian Peasland
> > > > peasland_at_msn.com

--
Regards

Pete

Received on Mon Jul 19 1999 - 11:36:57 CDT