Question: PL/SQL and Triggers Could I please get help on these problems? Thank you 1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name, and

PL/SQL and Triggers

Could I please get help on these problems? Thank you

PL/SQL and Triggers Could I please get help on these problems? Thankyou 1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name,and Hours, and the table PAYDATA with attributes Regular, Overtime, and Cutoff,defined and populated by the following script: DROP TABLE EMPLOYEE CASCADE CONSTRAINTS;CREATE TABLE EMPLOYEE I D Name Hours CHAR (7) , VARCHAR2 (12),

1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name, and Hours, and the table PAYDATA with attributes Regular, Overtime, and Cutoff, defined and populated by the following script: DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE EMPLOYEE I D Name Hours CHAR (7) , VARCHAR2 (12), NUMBER (3), CONSTRAINT PK EMPLOYEE PRIMARY KEY (ID) INSERT INTO EMPLOYEE VALUES ('7174311', "Pierson', 50) INSERT INTO EMPLOYEE VALUES ('0133899', 'Schneider', 20) INSERT INTO EMPLOYEE VALUES '6175427', 'Strickland', 25); INSERT INTO EMPLOYEE VALUES ('9714828', 'Wilson', 35) SELECT FROM EMPLOYEE; DROP TABLE PAYDATA; CREATE TABLE PAYDATA Regular Overtime Cutoff NUMBER (4,2), NUMBER (4, 2), NUMBER (2) INSERT INTO PAYDATA VALUES (12.00, 15.00, 30) SELECT * FROM PAYDATA; COMMIT Write a script file Problem1.sql containing an anonymous PL/SOL block that will do the following: 1 (PL/SQL Programming) Consider the table EMPLOYEE with attributes ID, Name, and Hours, and the table PAYDATA with attributes Regular, Overtime, and Cutoff, defined and populated by the following script: DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE EMPLOYEE I D Name Hours CHAR (7) , VARCHAR2 (12), NUMBER (3), CONSTRAINT PK EMPLOYEE PRIMARY KEY (ID) INSERT INTO EMPLOYEE VALUES ('7174311', "Pierson', 50) INSERT INTO EMPLOYEE VALUES ('0133899', 'Schneider', 20) INSERT INTO EMPLOYEE VALUES '6175427', 'Strickland', 25); INSERT INTO EMPLOYEE VALUES ('9714828', 'Wilson', 35) SELECT FROM EMPLOYEE; DROP TABLE PAYDATA; CREATE TABLE PAYDATA Regular Overtime Cutoff NUMBER (4,2), NUMBER (4, 2), NUMBER (2) INSERT INTO PAYDATA VALUES (12.00, 15.00, 30) SELECT * FROM PAYDATA; COMMIT Write a script file Problem1.sql containing an anonymous PL/SOL block that will do the following

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!