Home » SQL & PL/SQL » SQL & PL/SQL » Order by - pl help!! (Oracle 9i)
Order by - pl help!! [message #279142] Wed, 07 November 2007 02:05 Go to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Is

order by
NVL(TO_DATE( prev_date,'DD/MM/YYYY'), TO_DATE(curr_date,'DD/MM/YYYY')), TO_DATE(prev_date,'DD/MM/YYYY'),
from_tx_sid, version, curr_date--------------------1

similar to

order by
NVL(TO_DATE( prev_date,'DD/MM/YYYY'), TO_DATE(curr_date,'DD/MM/YYYY')),
from_tx_sid, version, curr_date---------------------2

In my opinion, the "TO_DATE(prev_date,'DD/MM/YYYY')" in point no 1 is redundant.

Thanks in advance.
Re: Order by - pl help!! [message #279147 is a reply to message #279142] Wed, 07 November 2007 02:08 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'd say that the second occurrent of Prev_Date is irrelevant in the first order by.
Previous Topic: PL/SQL for hierarchy
Next Topic: Populate Specific tabs in Excel Sheet using UTL File.
Goto Forum:
  


Current Time: Thu Dec 08 18:30:25 CST 2016

Total time taken to generate the page: 0.05224 seconds