Re: Need help with query in Oracle 8.1.7
From: Brian K <mailregdump_at_gmail.com>
Date: Fri, 24 Oct 2008 14:07:09 GMT
Message-ID: <gEkMk.117894$sg2.86431@fe09.news.easynews.com>
>
> Insufficient data :)
>
> I was wondering where PL/SQL came into it.
>
> -g
Date: Fri, 24 Oct 2008 14:07:09 GMT
Message-ID: <gEkMk.117894$sg2.86431@fe09.news.easynews.com>
On Fri, 24 Oct 2008 06:39:42 -0700, gazzag wrote:
> On 24 Oct, 13:23, "Shakespeare" <what..._at_xs4all.nl> wrote:
>> ============================================== Wouldn't a select max( ) >> group by >> >> be enough to do the job? >> >> Shakespeare- Hide quoted text - >> >> - Show quoted text -
>
> Insufficient data :)
>
> I was wondering where PL/SQL came into it.
>
> -g
I will post schema and some sample data.
The main problem I'm having is that the date field is date formatted, but they neglected to include the actual time.
So, when I'm trying to do date/time functions I invariably end up trying to parse the date and time as something like '10-Oct-08 00:00:00 12:31:56'.
Well, the main problem is actually my complete ignorance of oracle functions, but that's beside the point. Received on Fri Oct 24 2008 - 09:07:09 CDT