Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Lab Manual For Database Development

Authors: Rachelle Reese

1st Custom Edition

1256741736, 978-1256741732

More Books

Students also viewed these Databases questions