Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
ZDERAAN 515.123.4569 AHUNOLD 590.423.4567 BERNIT DAUSTIN 590.423.4569 VFATABAL590.423.4560 De Raan 100 102 13-JAN-01 AD VP 03-JAN-06 IT PROG 21-MAY-07 1T PROG 25-JUN-05 IT PROO 05-FEB-06 1T PROG 07-FEB-07 IT PROG 17-AUG-02 FI MOR 16-AUO-02 FI ACCOUNT 28-SEP-05 FI ACCOUNT 30-SEP-0s rI ACCOUNT 17000 9000 6000 4000 4000 4200 12008 9000 8200 7700 07-MAR-06 rI ACCOUNT 7800 07-DEC-07 rI ACCOUNT 6900 Enul1) (null) (null) (null) Inul1) (null) (null) (null) 103Alexandez Runald 104 Bruce Enst 590.423.4560 103 105David 10e Valli 107 Diana 100 Nandy 10Danie2 110 John 1111smael 112 Jose Manuel Urman 113Luis Austin Pataballa Lorentz Greenberg 103 103 103 101 DLORENTE 590.423.5567 NGREENBE515.124.4569 DEAVIET 515.124.4169 515.124.4269 1SCIARRA S15.124.4369 JMURMAN S15.124.4469 515.124.4567 Faviet 108 100 108 100 108 Chen seiarra JCHEN (nul1) tnull) Inull) (null) Popp LPOPP Create PL/SQL Trigger named 'DeleteChek' that will be fired when the us elete employees who have the job_id of 'IT PROG' or 'FI ACCOUNT' and it splay the following message "You are not allowed to and delete an emplo working in this job". Fire the trigger using proper SQL statement.

ZDERAAN 515.123.4569 AHUNOLD 590.423.4567 BERNIT DAUSTIN 590.423.4569 VFATABAL590.423.4560 De Raan 100 102 13-JAN-01 AD VP 03-JAN-06 IT PROG 21-MAY-07 1T PROG 25-JUN-05 IT PROO 05-FEB-06 1T PROG 07-FEB-07 IT PROG 17-AUG-02 FI MOR 16-AUO-02 FI ACCOUNT 28-SEP-05 FI ACCOUNT 30-SEP-0s rI ACCOUNT 17000 9000 6000 4000 4000 4200 12008 9000 8200 7700 07-MAR-06 rI ACCOUNT 7800 07-DEC-07 rI ACCOUNT 6900 Enul1) (null) (null) (null) Inul1) (null) (null) (null) 103Alexandez Runald 104 Bruce Enst 590.423.4560 103 105David 10e Valli 107 Diana 100 Nandy 10Danie2 110 John 1111smael 112 Jose Manuel Urman 113Luis Austin Pataballa Lorentz Greenberg 103 103 103 101 DLORENTE 590.423.5567 NGREENBE515.124.4569 DEAVIET 515.124.4169 515.124.4269 1SCIARRA S15.124.4369 JMURMAN S15.124.4469 515.124.4567 Faviet 108 100 108 100 108 Chen seiarra JCHEN (nul1) tnull) Inull) (null) Popp LPOPP Create PL/SQL Trigger named 'DeleteChek' that will be fired when the us elete employees who have the job_id of 'IT PROG' or 'FI ACCOUNT' and it splay the following message "You are not allowed to and delete an emplo working in this job". Fire the trigger using proper SQL statement.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
EMPLOVEL RSTE 100 ateven 101 Neena 102 Lex 103Alexander 104 Bruce LAT E King Eochhar IMAR SKING NEOCNHAR515.123.4568 LDERAAN 515.123.4569 AHUNOLD S9o.423.4567 BERNIT DAUSTIN 590.423.4569 VFATABAL 590.423.4560 DLORENTE 590.423.5567 NGREENBE 515.124.4569 DEAVIET 515.124.4169 row DATE 17-JUN-03 AD PRES 21-SEP-05 AD VP SALARY Coe THAA D DEARTED 24000 17000 17000 9000 000 4000 4000 515.123.4567 (null) 100 (nul1) (null) (nul1) (nul1) (nul1) (null) (null) (nul1) 90 90 90 De Haan 13-JAN-01 AD VP 03-JAN-0 IT PROG 21-MAY-07 17 PROG 25-JUN-05 1T PROO 05-FEB-06 IT PROG 07-FEB-07 IT PROG 17-AU-02 FI MOR 100 102 103 103 Runold 590. 423.4560 60 60 105 David 106 Valli 107Diana 100 Nancy 10 Daniel 110 John 1111smael 112 Jose Manuel Uzman 113 Luis Austin Pataballa Lorentz Greenberg Faviet 103 103 101 4200 1200 9000 28-SEP-05 FI ACCOUNT 8200 7700 7800 07-DEC-07 rI ACCOUNT 6900 60 100 100 100 100 100 100 (nul1) 16-AUG-02 FI ACCOUNT (null) (nul1) (null) (nul1) (null) 108 100 108 108 108 Chen JCHEN 515.124.4269 1SCIARRA S1s.124.4369 JMURMAN S15.124.4469 LPOPP sciarra 30-SEP-05 rI ACCOUNT 07-MAR-06 rI ACCOUNT Popp 515.124.4567 a) Create PL/SQL Trigger named 'DeleteChek' that will be fired when the user try to delete employees who have the job_id of 'IT PROG' or 'FI ACCOUNT' and it will display the following message "You are not allowed to and delete an employee who is working in this job". Fire the trigger using proper SQL statement.
Transcribed Image Text:EMPLOVEL RSTE 100 ateven 101 Neena 102 Lex 103Alexander 104 Bruce LAT E King Eochhar IMAR SKING NEOCNHAR515.123.4568 LDERAAN 515.123.4569 AHUNOLD S9o.423.4567 BERNIT DAUSTIN 590.423.4569 VFATABAL 590.423.4560 DLORENTE 590.423.5567 NGREENBE 515.124.4569 DEAVIET 515.124.4169 row DATE 17-JUN-03 AD PRES 21-SEP-05 AD VP SALARY Coe THAA D DEARTED 24000 17000 17000 9000 000 4000 4000 515.123.4567 (null) 100 (nul1) (null) (nul1) (nul1) (nul1) (null) (null) (nul1) 90 90 90 De Haan 13-JAN-01 AD VP 03-JAN-0 IT PROG 21-MAY-07 17 PROG 25-JUN-05 1T PROO 05-FEB-06 IT PROG 07-FEB-07 IT PROG 17-AU-02 FI MOR 100 102 103 103 Runold 590. 423.4560 60 60 105 David 106 Valli 107Diana 100 Nancy 10 Daniel 110 John 1111smael 112 Jose Manuel Uzman 113 Luis Austin Pataballa Lorentz Greenberg Faviet 103 103 101 4200 1200 9000 28-SEP-05 FI ACCOUNT 8200 7700 7800 07-DEC-07 rI ACCOUNT 6900 60 100 100 100 100 100 100 (nul1) 16-AUG-02 FI ACCOUNT (null) (nul1) (null) (nul1) (null) 108 100 108 108 108 Chen JCHEN 515.124.4269 1SCIARRA S1s.124.4369 JMURMAN S15.124.4469 LPOPP sciarra 30-SEP-05 rI ACCOUNT 07-MAR-06 rI ACCOUNT Popp 515.124.4567 a) Create PL/SQL Trigger named 'DeleteChek' that will be fired when the user try to delete employees who have the job_id of 'IT PROG' or 'FI ACCOUNT' and it will display the following message "You are not allowed to and delete an employee who is working in this job". Fire the trigger using proper SQL statement.
desc employees 11 12 Script Output x Task completed in 0.045 seconds 14 15 Name Null? 51 pe 18 EMPLOYEE ID NOT NULL NUMBER (6) FIRST NAME VARCHAR2 (20) 21 LAST NAME NOT NULL VARCHAR2 (25) EMAIL NOT NULL VARCHAR2 (25) 24 PHONE NUMBER VARCHAR2 (20) - HIRE DATE NOT NULL DATE JOB ID NOT NULL VARCHAR2 (10) - SALARY NUMBER (8,2) COMMISSION PCT NUMBER (2,2) MANAGER ID NUMBER (6) DEPARTMENT ID NUMBER (4)
Transcribed Image Text:desc employees 11 12 Script Output x Task completed in 0.045 seconds 14 15 Name Null? 51 pe 18 EMPLOYEE ID NOT NULL NUMBER (6) FIRST NAME VARCHAR2 (20) 21 LAST NAME NOT NULL VARCHAR2 (25) EMAIL NOT NULL VARCHAR2 (25) 24 PHONE NUMBER VARCHAR2 (20) - HIRE DATE NOT NULL DATE JOB ID NOT NULL VARCHAR2 (10) - SALARY NUMBER (8,2) COMMISSION PCT NUMBER (2,2) MANAGER ID NUMBER (6) DEPARTMENT ID NUMBER (4)
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS