Sql Triggers🔫 Real Life Example | SQL Interview♟ Questions🎯

preview_player
Показать описание

► Structured Query Language (SQL)(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Database Management System(Complete Playlist):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Рекомендации по теме
Комментарии
Автор

Sir plzz make such videos for pl/sql cursors, functions and so.

adeshbhore
Автор

Legend are watching one day before exam 😎

the_animeflix
Автор

We are required to support fetching of rows from start to end from a result set in PL SQL and are not required to go to the previous row in the result set. Which among the following PL SQL features can we use for the same? External | Implicit | Forward | None of the Cursors
Sir could you explain this?

atulkprajapati
Автор

Thank you for your expertise. On a related subject, I have numerous Java applications that call SQL stored procedures to handle DML updates to tables. My question is.... how might the after-update trigger capture the name of the stored procedure that performed the data modification?

ColonelStraker
Автор

(This will work in mySQL)

delimiter $$
create trigger t1
before delete on employee
for each row
begin
insert into employee_backup values(old.employee_name, old.age, old.salary);
end; $$

smitmodi
Автор

Mere भाई सच में गज़ब पढ़ाते हो तुम, 💯❤️👍

dishacoachingclasseskairan
Автор

I finally understand SQL triggers. Thank you so much.

salonisood
Автор

I think nobody can explain trigger wonderfully than u

mehakguptabcomsem
Автор

Sir triggers aur cursors pr videos bana dijiye taaki hamari help ho sakey aapne saare topics pr videos banayi hui hai magr inn do pr nhi banayi yhi toh important hai sir exams ke liye maine net pr search Kiya iss topic ke related pr koi bhi channel achey se nhi smjha saka pls sir jitni jldi ho saktey bana dijiye mere exams hai fifth of next month se sir final hai aur mujhe yhi do chapters bilkul nhi aatey pl sqql baaki Sara aata hai apke channel ki wajah se pls sir ye ek student ki request hai apne teacher se pls sir daal dijiye jitni jldi ho saktey hum wait krengey pls sir

daminimehta
Автор

Hi Sir,
Can you please make a tutorial for the data warehouse concept with examples? like Dimensional and fact tables etc..

rajeshk
Автор

love u sir, aap bahut acche aur easy tarike se samjhate ho

vikashkumargoswami
Автор

Thank you bhai samajh me aa gaya trigger kya hota hai...

kamleshpatil
Автор

thank you for clearing the whole concept of the trigger 😊😊

harshiljoshi
Автор

thank you so much sir, i stuck for so many hrs, finally understand that where i was stucking.thanks a lot sir.

rajasreelaha
Автор

Plz make video on dimentional and fact table

vinayakingle
Автор

Hlo sir
Pls make the video on NOSQL
Before 8 dec

Samrakahlon
Автор

Main table ka view bhi bna sakte hai na

punammisal
Автор

Sir is this playlist is complete SQL if not please continue the series sir please sir

PallabChatterjee
Автор

Sir please make video for sqlite3 concept

truptiradadiya
Автор

Sir if I like to write this as .. create or replace after delete on main for each row ... Then what will happen... I just placed after in place of before. Thanks

Mehedihasan-rahat