Learn about Trigger Basics in Oracle 11g PL/SQL Programming Part 2 course from GogoTraining.com

http://www.gogotraining.com, 1-877-546-4446
This video discusses:
•Triggers
•Define Characteristics of Database Triggers

This video is part of the Oracle 11g PL/SQL Programming Part 2 course which
picks up right where Part 1 completes and continues to guide you through more intermediate PL/SQL topics. Through hands-on exercises, you learn to handle all types of runtime errors, use explicit cursor processing including cursor FOR loops, create and use stored procedures and functions, and design and use PL/SQL packages as well as understand the benefits of using packages. This Oracle programming course teaches you to manage dependencies between these PL/SQL stored units, and understand and manage security for them as well. Also covered in this Oracle training is learning how to automate processing by creating triggers to solve business requirements including 11g compound triggers.

Coures Prerequisites:
SQL, previous programming experience,Oracle Database 11g: PL/SQL Programming Part 1

Course Objectives:
As a result of taking this Oracle programming course, you will be able to:
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Handle runtime errors
• Design PL/SQL anonymous block that execute efficiently
• Create and use stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Manage dependencies between PL/SQL subprograms
• Use conditional compilation to customize functionality in a PL/SQL block
• Create overloaded package subprograms
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and schedule jobs.
• Write dynamic SQL for coding flexibility
• Understand security for stored PL/SQL units
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
• Create triggers to solve business requirements including 11g compound triggers
• Use the 11g PL/SQL function cache

http://www.gogotraining.com, 1-877-546-4446

Category:

Education

Tags:

• Oracle
• Oracle 11g PL/SQL
• Oracle programming
• Trigger

[mmmooommmzaz]

how to make a trigger that checks salary of an employee according to his job_id minimum and maximum salary ?? i tried to do it with a check constraint but i failed

could you please answer my question ??