Scott_PLSQL

Scott_PLSQL - PL/SQL Startup Accelerator David Scott Intec...

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

View Full Document Right Arrow Icon
PL/SQL Startup Accelerator David Scott Intec Telecom Systems
Background image of page 1

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

View Full DocumentRight Arrow Icon
Why use PL/SQL? Fast Close Powerful Flexible Extensible Secure DATA Program PL/SQL Traffic Traffic
Background image of page 2
Getting Started with PL/SQL SQL*Plus and text editor TOAD Oracle PL/SQL Developer Third-party tools Shareware/Freeware … and a database …
Background image of page 3

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

View Full DocumentRight Arrow Icon
Program units Anonymous blocks Used in SQL scripts Functions and procedures Smaller units Triggers Keep ‘em short! Packages Advantages vs. functions and procedures
Background image of page 4
Uses As program In scripts Called from other programs Used in SELECT statement Use in SQL*Loader
Background image of page 5

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

View Full DocumentRight Arrow Icon
Basic programming structure Header Parameters Declare Variables, cursors, records Using %rowtype vs. records vs. variables Begin Executable statements Exception Error handling Default behavior
Background image of page 6
Controlling Execution IF – THEN CASE statements Function and procedure calls Loops While Numeric Cursor
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
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 / 19

Scott_PLSQL - PL/SQL Startup Accelerator David Scott Intec...

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

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