ERROR AND EXCEPTION HANDLING PLSQL handles the errors caused at the server level and publishes them using the following functions: EXCEPTION Thisdatatype is declared in DECLARE section of the PLSQL code enables to call those as and when they are

PL/SQL TUTORIALS – DYNAMIC SQL PL/SQL Tutorials – DYNAMIC SQL Within PL/SQL, you can execute any kind of SQL statement (even data definition and data control statements) without resorting to cumbersome programmatic approaches. Dynamic SQL blends seamlessly into your programs,

MY FIRST PROGRAM  PLSQL Tutorials – MY FIRST PROGRAM IN PL/SQL DBMS_OUTPUT This supplied package is an essential tool to debug the program written. So, use this and write your first program. This package prints the output of the program

ONLINE MOVE PARTITION EXAMPLES SQL> ALTER TABLE test1 MOVE PARTITION test1_PART1 ONLINE;  Table altered  SQL> ALTER TABLE test1 MOVE PARTITIONtest1_PART1 ONLINE UPDATE INDEXES;  Table altered  SQL> ALTER TABLE test1 MOVE PARTITIONtest1_PART1 ONLINE UPDATE GLOBAL INDEXES;  Table altered Source: Oracle

PL/SQL TUTORIALS – DYNAMIC SQL PL/SQL Tutorials – DYNAMIC SQL Within PL/SQL, you can execute any kind of SQL statement (even data definition and data control statements) without resorting to cumbersome programmatic approaches. Dynamic SQL blends seamlessly into your programs,