I'm having trouble with "group by" using varchar2 columns, i.e. group by
varchar2 columns does not return result set in the order of the group by
columns.

Example:

select cmpl_name, well_num
from l_wlcmp
group by cmpl_name, well_num
...does not return result set in cmpl_name order

But this query does...

select rpad(cmpl_name, 30, ' '), well_num
from l_wlcmp
group by rpad(cmpl_name, 30, ' '), well_num
... Does return result set in cmpl_name order

Anyone else have this problem? Is there a setting somewhere to correct
this issue at a high level without changing all the SQL code?

Thanks,

Jim Yates

-----Original Message-----
From: Stacy Gaddy
[mailto:oracledba-ezmlmshield-x40990496.[Email address protected]
Sent: Wednesday, August 31, 2005 7:29 AM
To: LazyDBA Discussion
Subject: Re: RAC Oracle 9i Windows 2000 NT server

get yourself to technet.oracle.com before posting these types of
questions here.

Stacy

On Wednesday 31 August 2005 5:48 am, Sreedhar_Bhaskararaju wrote:
> Dear All,
>
> Can you please share if any of you have documentation/links regarding

> RAC (Real Application Cluster) on Oracle 9i under Windows platfrom.
>
> Thanks to one and all.
>
> Regs,
> Sree
>
>
> DISCLAIMER:
> This email (including any attachments) is intended for the sole use of

> the intended recipient/s and may contain material that is CONFIDENTIAL

> AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
> copying or distribution or forwarding of any or all of the contents in

> this message is STRICTLY PROHIBITED. If you are not the intended
> recipient, please contact the sender by email and delete all copies;
> your cooperation in this regard is appreciated.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:

> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree

> to these terms:http://www.lazydba.com/legal.html

--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.[Email address protected]


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


-----------------------------------------
Anadarko Confidentiality Notice:
This electronic transmission and any attached documents or other
writings are intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential
or otherwise protected from disclosure. If you have received this
communication in error, please immediately notify sender by return
e-mail and destroy the communication. Any disclosure, copying,
distribution or the taking of any action concerning the contents of
this communication or any attachments by anyone other than the named
recipient is strictly prohibited.


Oracle LazyDBA home page