Write a PLSQL program that copies the departments located in 'CBE'
Create a program that copies the departments located in 'CBE' to a table called 'DEPARTMENT_CBE. Do not use a cursor FOR loop. Display how many rows were copied else display the message 'No Records found'.
Please check the attachment for additional information.
You can try this.
Insert into department_cbe
Select * from department
Where loc_id = 'CBE';
If sql%found then
Dbms_output.put_line(sql%rowcount || ' Record(s) got copied');
Dbms_output.put_line('No records found');
When others then