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
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