This course introduces students to PL/SQL and explains the benefits of this programming language. Participants learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. The course also imparts how to create anonymous PL/SQL blocks, stored procedures, and functions.
Participants learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are available as optional tools. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.
Learn To:Conditionally control code flow (loops, control structures) Use Explicit Cursors Handle runtime errors Describe stored procedures and functions Work with Composite Data Types Declare PL/SQL Variables
- Handle runtime errors
- Describe stored procedures and functions
- Use cursors to process rows
- Design PL/SQL anonymous block that execute efficiently
- Describe the features and syntax of PL/SQL
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.See all Global Knowledge Egypt courses