Forum

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

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

4 Posts
2 Users
0 Reactions
3,023 Views
Posts: 1
Topic starter
(@Rahul U)
Joined: 6 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: 46
(@Sambit S)
Joined: 6 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: 6 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
Posts: 17
(@rahul)
Active Member
Joined: 6 years ago

sir getting this error after compilation


Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: