Aug 09, 2020 6:06 am
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.
3 Replies
Aug 09, 2020 6:24 am
You can try this.
Begin
Insert into department_cbe
Select * from department
Where loc_id = 'CBE';
Commit;
If sql%found then
Dbms_output.put_line(sql%rowcount || ' Record(s) got copied');
Else
Dbms_output.put_line('No records found');
End if;
Exception
When others then
Rollback;
End;