Question: 1. Write SQL/PLSQL to perform the following functionality: - a. Create table LOG_TRIG_TABLE(USER_ID, LOG_DATE,ACTION). b. Create system trigger which logs the sign-in/out from the database.

1. Write SQL/PLSQL to perform the following functionality: - a. Create table LOG_TRIG_TABLE(USER_ID, LOG_DATE,ACTION). b. Create system trigger which logs the sign-in/out from the database.

-------------------------------------------------------------------------------------------------------- 2. Write trigger which prevents any CRUD operations on EMPLOYEES table in weekends.

-------------------------------------------------------------------------------------------------------------------- 3. Write stored function which accepts a numeric parameter called hire_year and gets the following employees information for any employee hired in hire_year : - EMP_ID, FULL_NAME, EMAIL, JOB_ID, JOB_NAME, DEPT_ID, DEPT_NAME, SALARY

--------------------------------------------------------------------------------------------------------------------- 4. Write an example for mutating table using triggers.

-----------------------------------------------------------------------

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!