Forum

Write a PLSQL progr...
 
Share:
Notifications
Clear all

Write a PLSQL program that copies the departments located in 'CBE'


Posts: 1
Guest
Topic starter
(@Rahul U)
New Member
Joined: 4 years ago

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
Posts: 47
Guest
(@Sambit S)
Eminent Member
Joined: 4 years ago

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;

Reply
1 Reply
(@rahul)
Joined: 4 years ago

Active Member
Posts: 17

@Sambit S sir it worked but output is different i want Record(s) got find one 

but is giving no record found

Reply

Self Learning Video Tutorials - Software Course

Posts: 17
(@rahul)
Active Member
Joined: 4 years ago

sir getting this error after compilation

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: