Sql Triggers🔫 Real Life Example | SQL Interview♟ Questions🎯
Вставка
- Опубліковано 5 жов 2024
- 👉Subscribe to our new channel: / @varunainashots
► Structured Query Language (SQL)(Complete Playlist):
• Structured Query Langu...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on UA-cam: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
Sir plzz make such videos for pl/sql cursors ,functions and so. On.....
Legend are watching one day before exam 😎
All the best bro
Not one day before but on the day
1 hour before exam😂😂
Same 😂@@tanishadhakad.17
20 min before the exam
I finally understand SQL triggers. Thank you so much.
Which university??
Mere भाई सच में गज़ब पढ़ाते हो तुम, 💯❤️👍
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?
I think nobody can explain trigger wonderfully than u
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?
(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; $$
What about this 👉 :
@@RahulVerma-ri4yv anything can be used as delimiter...as I use '/'
Sir! You re the real gem of CS
Sir 1 साल से ट्राई कर रहा हु जॉब के लिए SQL and plSQL developer position के लिए, लेकिन सर कुछ ज्यादा responce नही है
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
Hi Sir,
Can you please make a tutorial for the data warehouse concept with examples? like Dimensional and fact tables etc..
Excellent guruji
wow sir amazing thank you 💌💌
Hlo sir
Pls make the video on NOSQL
Before 8 dec
thank you for clearing the whole concept of the trigger 😊😊
Sir thank you for clearing concept☺☺
love u sir, aap bahut acche aur easy tarike se samjhate ho
Plz make video on dimentional and fact table
very nice sir , you are great
Sir please make a whole plsql series.
thank you so much sir,i stuck for so many hrs,finally understand that where i was stucking.thanks a lot sir.
Thank you bhai samajh me aa gaya trigger kya hota hai...
Thank you
Thank you so much Sir G
you are great sir ...
Sir please make video for sqlite3 concept
Sir is this playlist is complete SQL if not please continue the series sir please sir
THANK YOU SO MUCH ❤❤
sir when 1 row deleted form main table and insert into backup table then we can back the data into main table or not
Tx you sir
plz make a video store procedure and functions in mysql database sir
Good explanation techer thanks
Sir can you please make videos on pl sql
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
HOW TO RETRIVE THAT DATA BACK TO MAIN TABLE
Main table ka view bhi bna sakte hai na
Thanks sir
The main character 💯
thank you sir 👍👍👍👍👍😇😇😇😇😇😇😇
Sir add this video in your dbms series today I gave my exam and this question come and I didn't attempted 😢
Is this will work for Drop and Truncate?
Sir!! please start Madhya Pradesh ITI Training Officer (COPA) course. 🙏🏻🙏🏻🙏🏻
Thank u. My concept is clear about trigger. But while i performing mentioned query in sql server its not working.
Sir give same example triggee but query in ms-SQL these query not run in ms-sql
Sir please start a course for hpsc pgt computer science
Thank you 🥳
CREATE TRIGGER tr_Main
ON main
AFTER DELETE
AS
BEGIN
INSERT INTO Backup_table (id, Name)
SELECT id, Name
FROM deleted;
END
This is my approach of solving in sql server.
do not use triggers, we used triggers and they put alot of load on database.
वाय बींग ऑन द इंट्रो😅😅
I make same 2same program but trigger is not create it give us error incorrect syntax near before
why we are using before ?please someone explain
Why do we use colon before old
sir command are not work in oracal 10g (create or replace trigger t1
before delete on main
for each row
begin
insert into backup values(old.id, old.salary);
end;) show an error like (ORA-04089: cannot create triggers on objects owned by SYS) . sir please solve it............
:old instead of old
Aur backup table me se main table m kaise data wapas laaye
Will this work on MYSQL
Before one hour of exam bro
Understood
Mujhe samaj nahi aaya
Toh like👍🏻 nhi,
Dislike👎🏻 kare 😉😉
I humbly request you to start the course of "Informatics Assistant(Rajasthan)".
Please Koi Bhai Ye program bnade C language me 🙏🙏 bari mehrbani hogi
Q.1) Prompt the user for his/her year of birth and if the year is a leap year print “you were born in a leap year” , otherwise print the age of the user. (using function named leap year ())
google it
#include
#include
int main() {
int year_of_birth, is_leap_year, age_in_c;
time_t t = time(NULL);
struct tm current_time = *localtime(&t);
printf("What year were you born in? ");
scanf("%d", &year_of_birth);
// Check if the year is a leap year
if ((year_of_birth % 4 == 0 && year_of_birth % 100 != 0) || year_of_birth % 400 == 0) {
printf("You were born in a leap year!
");
} else {
// Calculate the age of the user in C
age_in_c = current_time.tm_year + 1900 - year_of_birth + 1; // Adding 1 to account for the current year
printf("You are %d years old in C.
", age_in_c);
}
return 0;
}
I added tm_year+1900 because tm_year starts from 1900
How to do in ms-SQL SsMs
jay ho
Legend are watching 5 min before exam
9 min before exam 💀
Subtitles please
You're so handsome
🔫SQL Trigger🔫
First view🥰
🧐🧐
Legends are watching after the exam
Back aagyi kya 😂😂😂
Thanks 😊