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
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
PLSQL Tutorials - MY FIRST PROGRAM IN PL/SQL
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
SQL> ALTER TABLE test1 MOVE PARTITION test1_PART1 ONLINE;
SQL> ALTER TABLE test1 MOVE PARTITION
test1_PART1 ONLINE UPDATE INDEXES;
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.
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.