Write a program to delete a record from a department table used in parameter to accept department number errors like deleting a foreign key value

1 begin

2 delete from dept_college where deptid=10;

3 exception

4 when others then

5 dbms_output.put_line('Connot delete ---foreign key violation');

6* end;

SQL> /

Output

PL/SQL procedure successfully completed.

SQL> select * from dept_college

2 /

DEPTID DEPTNAME LOCATION

--------- --------------- ----------

20 Anil Hyderabad

30 Accounting Banglore

40 Marketing Nagpur

50 Sunil Chennai