[solved]-1 Write Trigger Employee Table Convert Following Upper Case Insert Update Employees Name E Q39016737
1. Write a trigger for the employee table which: • will convert the following to UPPER case during an INSERT or UPDATE: • Employees name • email • JOB_ID will write all data changes to a log table. Put SYSDATE into operationdate and USER into username. • Be sure to test it by trying all three operations. • First, create the log table as below: CREATE TABLE emplog (username VARCHAR2(40), operation CHAR(10), operationdate DATE enpid number); 2. Write a procedure that prints number of departments in each region along with the region name. Test the above procedure by writing a script which: • prompts the user for a beginning letter of region prompts the user for an ending letter of region calls the procedure to prints the required details with region name begining and ending with user inputs. 3. Create a table Employee_Details with the following attributes * EMPLOYEE_ID” , “FIRST_NAME”, “LAST_NAME”,”JOB_ID”,”MANAGER_ID”,”DEPARTMENT_ID”,”DEPARTMENT_NAME”, “LOCATION_ID”: • DataTypes are same as in employees and departments table. Create a PL/SQL block that reads data from employees and departments table and inserts it into Employee Details table. Use cursors for this questi Show transcribed image text 1. Write a trigger for the employee table which: • will convert the following to UPPER case during an INSERT or UPDATE: • Employees name • email • JOB_ID will write all data changes to a log table. Put SYSDATE into operationdate and USER into username. • Be sure to test it by trying all three operations. • First, create the log table as below: CREATE TABLE emplog (username VARCHAR2(40), operation CHAR(10), operationdate DATE enpid number); 2. Write a procedure that prints number of departments in each region along with the region name. Test the above procedure by writing a script which: • prompts the user for a beginning letter of region prompts the user for an ending letter of region calls the procedure to prints the required details with region name begining and ending with user inputs. 3. Create a table Employee_Details with the following attributes * EMPLOYEE_ID” , “FIRST_NAME”, “LAST_NAME”,”JOB_ID”,”MANAGER_ID”,”DEPARTMENT_ID”,”DEPARTMENT_NAME”, “LOCATION_ID”: • DataTypes are same as in employees and departments table. Create a PL/SQL block that reads data from employees and departments table and inserts it into Employee Details table. Use cursors for this questi
Expert Answer
Answer to 1. Write a trigger for the employee table which: • will convert the following to UPPER case during an INSERT or UPDATE… . . .
OR
