sounds like an order by in the select will solve the issue:
select cmpl_name, well_num
from l_wlcmp
group by cmpl_name, well_num
ORDER BY cmpl_name
Stacy
On Wednesday 31 August 2005 4:29 pm, Yates Jim wrote:
> -----Original Message-----
> From: Yates Jim
> [mailto:oracledba-ezmlmshield-x77467557.[Email address protected]
> Sent: Wednesday, August 31, 2005 3:22 PM
> To: LazyDBA Discussion
> Subject: RE: RAC Oracle 9i Windows 2000 NT server
>
> 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.
>
>
>
>
> --------
> 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
>
>
>
> --------
> 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]
Oracle LazyDBA home page