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: "ORDER BY" problems

Re: "ORDER BY" problems

From: Marc Billiet <Marc.Billiet_at_alcatel.be>
Date: 1997/07/29
Message-ID: <33DDC4DA.3C9@alcatel.be>#1/1

Martin Bronstein wrote:
>
> ORDER BY Decode(sort_title,null,title,sort_title)
>

You can also use :

order by nvl(sort_title,title)

Marc Billiet Received on Tue Jul 29 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: ChanderR_at_KochInd.com: "How to create temp table in memory in Oracle"
Previous message: Martin Bronstein: "Re: "ORDER BY" problems"
In reply to: Martin Bronstein: "Re: "ORDER BY" problems"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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