session9a (2)

session9a (2) - Oracle App. I2IT Oracle App. I2IT Oracle...

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

View Full Document Right Arrow Icon
Oracle App. I2IT
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
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 12 types of triggers Event Trigger before Trigger after Statemen t row Insert X X X X Update X X X X Delete X X X X
Background image of page 4
Oracle App. I2IT
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
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 Types of triggers For example: if the triggering event was an update which updates 100 rows, a row-level trigger will execute 100 times, and a statement level trigger will execute once.
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 Row Before trigger Typically, row before triggers are used for checking or modifying the data that will be inserted or updated. For example, a before trigger might be used to insert the current time into a timestamp column, or to check that two elements of the row are consistent.
Background image of page 16
Oracle App. I2IT Row after triggers Row after triggers are most sensibly used to propagate the updates to other tables, or make consistency checks against other tables
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 Examples Before delete-OnDeleteDept After insert: NOOFEMP
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
Oracle App. I2IT
Background image of page 20
Oracle App. I2IT
Background image of page 21

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

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

session9a (2) - Oracle App. I2IT Oracle App. I2IT Oracle...

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

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