Coding tabular reports in SQL

BANGALORE, INDIA: Oracle provides a wealth of extensions to the SQL language to enhance the productivity of SQL queries.  These extensions to standard SQL can be very useful for creating tabular reports directly from Oracle tables without the need for sophisticated query tools.

The greatest and least built-in functions are used to detect the highest and lowest values for a column.  The power of these functions become apparent when combined with the decode built-in function.  By using decode to change the ranges to a binary number, we can then use the sum built-in function to count the number of values within a specified range.

Click here to know more...!