cmadsen

cmadsen - ThePL/SQLProgramming Language:NewAdvances...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
    The PL/SQL Programming  Language: New Advances  With Oracle 10g Presented By: Chad Madsen
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
    What Is PL/SQL? Procedural Language/Standard Query  Language Allows the integration of standard SQL  with procedural program controls Supported only by Oracle databases
Background image of page 2
    Where Can It Be Used? Stored Procedures and functions Compiled and stored on Database Stand alone scripts Database Triggers Insert Update Delete
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
    What Can You Do With  PL/SQL? PL/SQL provides most of the common  controls offered by other modern  languages User defined variables If-else and Case statements Looping constructs Complex data structures
Background image of page 4
  Some Important Advantages PL/SQL recognizes the same data  types as defined in an Oracle database. Since the code can be compiled and  stored right in the database, the data  transfer time is kept to a minimum. Access to execute stored program units 
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 22

cmadsen - ThePL/SQLProgramming Language:NewAdvances...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online