PL/SQL Packages, Objects and Dynamic SQL
Training
Online
Description
-
Type
Training
-
Methodology
Online
-
Class hours
20h
This course follows through on the concepts learnt in PL/SQL Fundamentals. Here, we are introduced to the concept of packages and the use of Dynamic SQL in queries. On completing this course you should be equipped to write applications that are robust, more efficient and secure.
About this course
Fundamentals and coverage of the IT Foundation Program
SQL Fundamentals
PL/SQL Fundamentals
Reviews
Subjects
- .Net programming
- 3d Studio
- 3Com
Course programme
Creating PackagesUsing packagesMaintaining PackagesDML TriggerInstead-of TriggerSystem TriggerManaging triggersCreating Objects in PL/SQLInitializing Objects in PL/SQLManipulating Objects in PL/SQLOverview of Dynamic SQLDBMS_SQL packageOverview of Native Dynamic SQLUsing Native Dynamic SQL
PL/SQL Packages, Objects and Dynamic SQL