Home » SQL & PL/SQL » SQL & PL/SQL » Decode explanation
Decode explanation [message #605022] Mon, 06 January 2014 23:44 Go to next message
mist598
Messages: 948
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

    DECODE can be used to pivot "vertical" data to "horizontal"; 
    allow only particular matches into aggregate functions; 
    alter the WHERE, GROUP BY and ORDER BY dynamically, and more.


Please explain me with examples on the above data.

Thank You

[Updated on: Mon, 06 January 2014 23:45]

Report message to a moderator

Re: Decode explanation [message #605024 is a reply to message #605022] Mon, 06 January 2014 23:54 Go to previous messageGo to next message
pablolee
Messages: 2633
Registered: May 2007
Location: Scotland
Senior Member
No point regurgitating the VAST quantities of examples and discussions 'out there'. Here's an example page
Re: Decode explanation [message #605025 is a reply to message #605024] Tue, 07 January 2014 00:03 Go to previous message
mist598
Messages: 948
Registered: February 2013
Location: Hyderabad
Senior Member
Hi pablolee,

Thank You for help , i searched more on Decode i got link http://www.toadworld.com/platforms/oracle/w/wiki/4757.using-decode.aspx this one also having great explanation on Decode.


Thank you
Previous Topic: ORA-00907: missing right parenthesis
Next Topic: How to Display Multiple rows in a single row but in different columns
Goto Forum:
  


Current Time: Tue Sep 30 02:02:08 CDT 2014

Total time taken to generate the page: 0.10618 seconds