Re: Just as a learning exercise
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 4 May 2011 14:29:32 +0100
Message-ID: <BANLkTi=4X8PqOswx5WcsSgRsRpDOHZgipw_at_mail.gmail.com>
Based on the where 1=1 and lack if between I'd expect this to be machine written
Date: Wed, 4 May 2011 14:29:32 +0100
Message-ID: <BANLkTi=4X8PqOswx5WcsSgRsRpDOHZgipw_at_mail.gmail.com>
Based on the where 1=1 and lack if between I'd expect this to be machine written
On 4 May 2011 14:23, "Paul Drake" <bdbafh_at_gmail.com> wrote:
Thomas,
Why would anyone ever apply a TRUNC ( ) function to a date column in a where
clause?
Is there no possibility that one might want to index that column at some
point?
Are you that fond of having to create function based indexes just because
devs can't write decent SQL statements?
Paul
On Wed, May 4, 2011 at 9:10 AM, Thomas Day <tomdaytwo_at_gmail.com> wrote:
>
> I've got a query in A...
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 04 2011 - 08:29:32 CDT