Загрузка...

Oracle PLSQL Tutorial 38- Trigger Part 1 in Oracle PLSQL #plsql

In this Video, We are explaining about trigger in oracle plsql with their advantages and syntax of trigger in oracle plsql.

What is Trigger in Oracle PLSQL
A trigger in Oracle PL/SQL is a special type of stored procedure that automatically runs or "fires" when certain events occur in the database. Triggers are often used to enforce business rules, maintain data integrity, and perform automatic actions. Here’s a simple way to explain it.

Types of Trigger in Oracle PLSQL
Row Level Trigger
Statement Level Trigger
DML Trigger
DDL Trigger
Database Event Trigger
Before Trigger
After Trigger
Instead of Trigger

Advantages of Trigger
Automation
Data Integrity
Auditing and Logging
Prevent Invalid Transactions
Enforce Business Rule
Some other Video related to PL SQL tutorial.
Oracle PLSQL Tutorial 37- Package Part -2 with Example in PLSQL
https://youtu.be/teL8qdwYW8w

Oracle PLSQL Tutorial 36- Package Part -1 with Example in PLSQL
https://youtu.be/Y7dMNSB59i4

Oracle PLSQL Tutorial 35- PRAGMA EXCEPTION_INIT with Example in PLSQL
https://youtu.be/4MWu_AHMHbM

Oracle PLSQL Tutorial 34- RAISE_APPLICATION_ERROR with Example in PLSQL
https://youtu.be/qncI6ve1aR4

Oracle PLSQL Tutorial 33- User Defined Exception with Example in PLSQL
https://youtu.be/iu47_kfszw4

Oracle PL/SQL Tutorial 32- Exception Handling with Example in PLSQL
https://youtu.be/AokubrUjiXg

Oracle PL/SQL Tutorial 31- Parameter Modes in Procedure(IN,OUT,INOUT) with Example
https://youtu.be/-a6tqkz85pc

Oracle PL/SQL Tutorial 30- Stored Procedure in PLSQL with Example
https://youtu.be/6KoJPY5vA04

Oracle PL/SQL Tutorial 29- Function INOUT Parameter in PLSQL with Example
https://youtu.be/k1HUR7-uzfU

--------------------------------------------------------------------------------------------------------

Our Social Link:-
Link (Blogger) :
https://javainhand.com
Link (Facebook Group )
https://www.facebook.com/groups/145218296146795/?ref=bookmarks
Link (Facebook Page)
https://www.facebook.com/javainhand2017/

Видео Oracle PLSQL Tutorial 38- Trigger Part 1 in Oracle PLSQL #plsql канала JavaInhand Tutorial
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять