Shared Tutorials New
Website Development
2D & 3D Graphics
Audio & Video Editing
Databases
Desktop Programming
Operating Systems
Business Applications
Miscellaneous
Selected Reading
© 2011 TutorialsPoint.COM
|
Shared Tutorials Directory
Tutorials Shared by the Community
-
Today I was working on a data table, output in HTML generated by PL/SQL
http://joelennon.com/?q=node/583
Tutorial Statistics
Basically I have a procedure which takes a parameter (p_sort_by) and establishes which column to sort by based on this parameter. It does this using the DECODE function, which has similar functionality to IF-THEN-ELSE statements. I could have alternatively used CASE statements here, which are easier to understand, but they are not supported in older versions of Oracle. More detail...
|
|
|