lec_pl_sql

lec_pl_sql - Introduction to PL/SQL Introduction to PL/SQL...

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

View Full Document Right Arrow Icon
Introduction to PL/SQL
Background image of page 1

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

View Full DocumentRight Arrow Icon
Introduction to PL/SQL Procedural Language extension for SQL Oracle Proprietary 3GL Capabilities Integration of SQL Portable within Oracle data bases Callable from any client
Background image of page 2
Structure of PL/SQL PL/SQL is Block Structured A block is the basic unit from which all PL/SQL programs are built. A block can be named (functions and procedures) or anonymous Sections of block 1- Header Section 2- Declaration Section 3- Executable Section 4- Exception Section
Background image of page 3

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

View Full DocumentRight Arrow Icon
Structure of PL/SQL HEADER Type and Name of block DECLARE Variables; Constants; Cursors; BEGIN PL/SQL and SQL Statements EXCEPTION Exception handlers END;
Background image of page 4
Structure of PL/SQL DECLARE a number; text1 varchar2(20); text2 varchar2(20) := “HI”; BEGIN ---------- ---------- ---------- END; Important Data Types in PL/SQL include NUMBER, INTEGER, CHAR, VARCHAR2, DATE etc to_date(‘02-05-2007','dd-mm-yyyy') { Converts String to Date}
Background image of page 5

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

View Full DocumentRight Arrow Icon
Data Types for specific columns Variable_name
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

lec_pl_sql - Introduction to PL/SQL Introduction to PL/SQL...

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

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