Re: Need help with a query

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 03 Apr 2002 21:16:48 GMT
Message-ID: <3CAB7140.316C5C3B@exesolutions.com>

I know what you are trying to do is clear to you ... but it isn't to me. What is the definition of the last record?

And what is a VARCHAR1?

Daniel Morgan

Ryan Gaffuri wrote:

> I have 3 columns that are important.
>
> Primary_key
> VARCHAR1
> VARCHAR2
>
> This is for a master-detail form.
> The form is ordered by varchar1, varchar2
>
> I need to to select the last record. I cannot use the built in last
> record. Long story. Its causing problems. So I need to do the query
> myself.
>
> I am on forms 6i and Oracle 8i. I tried doing an order by in the where
> clause(that I thought I was supposed to be able to do in 8i?) in
> sqlplus and it did not recognize it.
>
> Also varchar2 can be null so this killed some subqueries I had going.
> The primary_key is based on a sequence.
>
> Thanks
Received on Wed Apr 03 2002 - 15:16:48 CST