Building examples of using SQL functions supported by Oracle Check the post here (in construction)

Single-row F Aggregate F Analytic F Object Reference F Model F OLAP F Single-row functions   Numeric functions  (26, 11gR2...

[ Oracle PL/SQL ] CONTINUE statement CONTINUE jumps out of the current LOOP interaction and STARTS THE NEXT ONE . Can be used on it...

Question: Can you use the same name for User-Defined Exceptions in nested blocks? A: Yes. But, oracle treat them as DIFFERENT exceptio...

[ Oracle PL/SQL ] With Oracle 11g: Native dynamic SQL and DBMS_SQL package now support statments larger than 32Kb . EXECUTE IMMEDIAT...

[ Oracle PL/SQL ] Native Dynamic SQL: OPEN FOR, FETCH and CLOSE Using dynamic SQL with OPEN FOR, FETCH and CLOSE: set serverout...

[ Oracle PL/SQL ] PL/SQL Compiler Several initialization parameters (compiler parameters) affect the compilation of PL/SQL units. The va...

[ Oracle PL/SQL ] About Packages: Schema object that groups logically related PL/SQL types , variables , constants , subprograms , cursor...