William Hill
Mon Aug 02, 2010 |
"Who am I" script - http://www.orafaq.com/scripts/sql/whoami.txt
Select the Nth highest value from a table - http://www.orafaq.com/scripts/sql/maxvalue.txt
Select the Nth lowest value from a table - http://www.orafaq.com/scripts/sql/minvalue.txt
Demonstrate default column values - http://www.orafaq.com/scripts/sql/default.txt
Count the number of rows for ALL tables in current schema - http://www.orafaq.com/scripts/sql/countall.txt
Demonstrate Oracle database types and object tables - http://www.orafaq.com/scripts/sql/objopt.txt
Demonstrate VARRAY database types - http://www.orafaq.com/scripts/sql/varray.txt
Demonstrate Oracle temporary tables - http://www.orafaq.com/scripts/sql/temptab.txt
# Delete duplicate values from a table - http://www.orafaq.com/scripts/sql/deldup.txt |