This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.
To be a more effective Oracle Developer, we recommend basic knowledge of Oracle DBA. We can offer a 1 day customized course on Oracle DBA after the first module SQL Fundamentals. To know more, please write to us at firstname.lastname@example.org.
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Design PL/SQL program units that execute efficiently
Use PL/SQL programming constructs and conditional control statements
Handle run-time errors
Describe stored procedures and functions
Write dynamic SQL for more coding flexibility
+91 753 300 8521
We look forward to hearing from you!
+91 704 259 3729
WhatsApp Chat now Available
Send us an Email
I came to Koenig Delhi for training on Oracle 11g database Release 2 workshop 1 . It was my very first visit to New Delhi. Before landing here I was little bit worried about the place and...
I came to Koenig Goa for training on Oracle Database 10g : Workshop Administration I.
I work as a programmer. I and five other colleagues decided to take the course "Oracle Database 10g...
I came to Koenig Delhi for training on Oracle Reports Developer 10g: Build Reports. I am trying to develop my career in Linux & Oracle. I attended training at Koenig Solutions in India. I found...
My name is Comfort. I came at Koenig Solutions Delhi for the course of Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data.
About the Training: It was a great experience with well...
It took me a lot of effort to convince my superiors for the courses in India. But it was all worth it.
Here everything works as a charm, without any hassle - the airport shuttle, the schedule of...