Forum

Write a PLSQL progr...
 
Notifications
Clear all

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


Rahul U
Posts: 1
 Rahul U
Topic starter
(@Rahul U)
Joined: 12 months 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
Sambit S
Posts: 47
 Sambit S
(@Sambit S)
Joined: 1 year 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 Updhyay
(@rahul)
Joined: 12 months 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
Rahul Updhyay
Posts: 17
(@rahul)
Active Member
Joined: 12 months ago

sir getting this error after compilation

Reply
Share: