Home
Developer Scripts
Dba Scripts
SQL
PL/SQL
Oracle Errors
Miscellaneous
FITNESS-KEEP FIT
Oracle Developer Scripts
Oracle Developer Scripts
Benchmark execution time for sql using Dbms_Utility.Get_Time
LIKE clause, used with ESCAPE
Calling a function in sql, which has the same name as a table column name.
Concataning "A.M. & P.M." to 24 hour format hours stored in a varchar2 column.
String Parsing 1 : Finding the greatest and least of numbers separated by comma within a string.
Oracle Developer Scripts
Caluculate the
average rowsize
of a table