session1

session1 - PL/SQL Oracle App. I2IT Oracle App. I2IT PL/SQL...

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

View Full Document Right Arrow Icon
Oracle App. I2IT 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
Oracle App. I2IT
Background image of page 2
Oracle App. I2IT PL/SQL PL/SQL Provides More like a programming language Declaration and use variables. Branching and looping constructs. Create functions and procedures. Explicit Exception Handling. Row-by-Row processing of data. (Cursors) Triggers-(piece if code that executes automatically on occurrence of an event)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT How PL/SQL Executes
Background image of page 4
Oracle App. I2IT PL/SQL engine The PL/SQL engine is a special component of many Oracle products, including the Oracle Server, that processes PL/SQL. The procedure (or package) is stored in a database. When an application calls a procedure stored in the database, Oracle loads the compiled procedure (or package) into the shared pool in the System Global Area (SGA), and the PL/SQL and SQL statement executors work together to process the statements within the procedure.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT The following Oracle products contain a PL/SQL engine: Oracle Server Oracle Forms (Version 3 and later) Oracle Reports (Version 2 and later)
Background image of page 6
Oracle App. I2IT
Background image of page 7

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 8
Oracle App. I2IT
Background image of page 9

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 10
Oracle App. I2IT
Background image of page 11

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 12
Oracle App. I2IT
Background image of page 13

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 14
Oracle App. I2IT
Background image of page 15

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 16
Oracle App. I2IT
Background image of page 17

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 18
Oracle App. I2IT
Background image of page 19

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

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

Page1 / 46

session1 - PL/SQL Oracle App. I2IT Oracle App. I2IT PL/SQL...

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

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