Question
Given the following table: Highschooler(studentID, studentName, grade); Write in PL/SQL a row level trigger named graduation . This trigger should be fired after updating the
Given the following table:
Highschooler(studentID, studentName, grade);
Write in PL/SQL a row level trigger named graduation. This trigger should be fired after updating the column grade of the above table. Once it is fired, it should delete students whose new grades exceed 12.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Transactions On Large Scale Data And Knowledge Centered Systems Vi Special Issue On Database And Expert Systems Applications Lncs 7600
Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou
2012th Edition
3642341780, 978-3642341786
