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.
SIKSHAPATH Latest Questions
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.
Write a program in PL/SQL to print factorial of a number.
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 ...
Create a trigger which will work before deletion in employee table and print a message “Deletion started”
Compare the deferred-modification and immediate-modification version of the log-based recovery schemes, in terms of ease of implementation and overhead cost