PL/SQL TUTORIALS - DYNAMIC SQL

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, making them more efficient, readable, and concise

ERROR AND EXCEPTION HANDLING

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 required.

MY FIRST PROGRAM

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 on to the screen.

You will read about many important supplied packages as you go forward.

ONLINE MOVE PARTITION EXAMPLES

ONLINE MOVE PARTITION EXAMPLES
 SQL> ALTER TABLE test1 MOVE PARTITION test1_PART1 ONLINE; 

Table altered 

SQL> ALTER TABLE test1 MOVE PARTITION
test1_PART1 ONLINE UPDATE INDEXES; 

PL/SQL TUTORIALS – CONCEPTS

PL/SQL TUTORIALS – CONCEPTS
PL/SQL Tutorials – CONCEPTS
PL/SQL is an acronym to Procedural Language/Structured Query Language.

When the business logic to be attained is not achievable easily using SQL which is 4th Generation Language, Oracle turns to the Procedural Language structures and achieves that business logic and achieves what business is looking for.

SOURCE SAVE

SOURCE SAVE
 Save the Source Code and Table and Index Structures using PL/SQL

After having gone through some papers on this subject, the need for a robust system has to be developed plugging all the holes, is felt and the result is this.

The basic idea and the first paper that has been seen is that of TOM, the great.