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: Functions and where vs. group-by inconsistency

Re: Functions and where vs. group-by inconsistency

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 06 Oct 2006 09:28:40 -0700
Message-ID: <1160152118.376849@bubbleator.drizzle.com>


Martin T. wrote:
> Hello all.
> (assuming Oracle 9.2)
>
> First of all, does anyone know why the Oracle SQL Parser will not allow
> us to use the <name>-part of "table.column AS <name>" in where or
> group-by clauses?? Is this just being lazy on their part, or is there
> an actual reason behind this?

Just read the above paragraph a second time. I have no idea what you are asking. Is the lack of clarity just being lazy on your part? ;-)

List the version to 4 decimal places when responding.

-- 
Daniel Morgan
Puget Sound Oracle Users Group
Received on Fri Oct 06 2006 - 11:28:40 CDT

Original text of this message

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