Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
Home/Computer Science/Page 79
SIKSHAPATH Latest Questions
rishabhsharma18
Asked: November 21, 2021In: DBMS
Write a program in PL/SQL to print factorial of a number.
SUMIT
Asked: November 21, 2021In: Mathematics
Solve the following problem using DPP Maximize Z = 2x1+5x2 Subject to constraints: 2x1+x2 ≤430 2x2 ≤ 460, x1, x2≥ 0
Advance Learner
Asked: November 21, 2021In: DBMS
Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one record (X=1, Y=1) is inserted in the table. Let MX and My denote the respective maximum values of ...
Satyam Kumar
Asked: November 20, 2021In: DBMS
Create a trigger which will work before deletion in employee table and print a message “Deletion started”
Ashish shah
Asked: November 20, 2021In: Data Structure