Create a procedure to delete certain records from a table
and display the total number of records deleted in this
process. (Condition for deletion can be of ur choice, for
instance delete all records where eid='')

Answers were Sorted based on User's Feedback



Create a procedure to delete certain records from a table and display the total number of records ..

Answer / manas

create or replace procedure proc_name(noofcount out number ) is
Begin
Delete from tes_tabt;
noofcount := sql%rowcount;
End

Is This Answer Correct ?    7 Yes 1 No

Create a procedure to delete certain records from a table and display the total number of records ..

Answer / mathivanan

Create or replace procedure delete_rec_cnt is
begin
delete from MY_TABLE;
dbms_output.put_line(sql%rowcount);
end;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is clustered and nonclustered index in sql?

0 Answers  


State the advatage and disadvantage of Cursor's?

2 Answers  


What is the difference between null value, zero, and blank space?

0 Answers  


counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,


How to find the count of letter "L" in HELLO

7 Answers   HP,


What is the use of index in sql?

0 Answers  


is it mandatory to select all the column in a view then what columns should be selected

2 Answers  


Which command is used to call a stored procedure?

0 Answers  


What is package in pl sql with an examples?

0 Answers  


How do I trace sql profiler?

0 Answers  


How to download oracle sql developer?

0 Answers  


What is the process of copying data from table a to table b?

0 Answers  


Categories