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
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 |
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 |
What is clustered and nonclustered index in sql?
State the advatage and disadvantage of Cursor's?
What is the difference between null value, zero, and blank space?
counting the no.of characters occurs in a string by using pl/sql function
How to find the count of letter "L" in HELLO
What is the use of index in sql?
is it mandatory to select all the column in a view then what columns should be selected
Which command is used to call a stored procedure?
What is package in pl sql with an examples?
How do I trace sql profiler?
How to download oracle sql developer?
What is the process of copying data from table a to table b?