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

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  


What is inner join in sql?

0 Answers  


How to pronounce postgresql?

0 Answers  


Can dml statements be used in pl/sql?

0 Answers  


What is input buffer in sql*plus?

0 Answers  


What is sql query optimization?

0 Answers  


what is global table

7 Answers   iFlex,


what is julian date in oracle

2 Answers  


3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,


what is a record in a database ? : Sql dba

0 Answers  


Why query optimization is needed?

0 Answers  


Is pl sql still used?

0 Answers  


Categories