ILT-OPLSQLE-CONTAINTS.docx - Introduction Course Objectives...

  • No School
  • AA 1
  • rekdix639
  • 5

This preview shows page 1 - 3 out of 5 pages.

Introduction Course Objectives Course Agenda Describe the Human Resources (HR) Schema PL/SQL development environments available in this course Introduction to SQL Developer Introduction to PL/SQL Overview of PL/SQL Identify the benefits of PL/SQL Subprograms Overview of the types of PL/SQL blocks Create a Simple Anonymous Block How to generate output from a PL/SQL Block? Declare PL/SQL Identifiers List the different Types of Identifiers in a PL/SQL subprogram Usage of the Declarative Section to Define Identifiers Use variables to store data Identify Scalar Data Types The %TYPE Attribute What are Bind Variables? Sequences in PL/SQL Expressions Write Executable Statements Describe Basic PL/SQL Block Syntax Guidelines Learn to Comment the Code Deployment of SQL Functions in PL/SQL How to convert Data Types? Describe Nested Blocks Identify the Operators in PL/SQL Interaction with the Oracle Server Invoke SELECT Statements in PL/SQL Retrieve Data in PL/SQL SQL Cursor concept Avoid Errors by using Naming Conventions when using Retrieval and DML Statements Data Manipulation in the Server using PL/SQL Understand the SQL Cursor concept Use SQL Cursor Attributes to Obtain Feedback on DML
Image of page 1
Save and Discard Transactions Control Structures Conditional processing using IF Statements Conditional processing using CASE Statements Describe simple Loop Statement Describe While Loop Statement Describe For Loop Statement Use the Continue Statement Composite Data Types Use PL/SQL Records The %ROWTYPE Attribute Insert and Update with PL/SQL Records
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '19
  • Control flow

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture