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='')
Answer Posted / 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 View All Answers
Name the different types of indexes in sql and define them.
Why trigger is used in sql?
What is a sql schema used for?
What is the difference between subquery and correlated query?
Can we join two tables without common column?
Does truncate table reset auto increment?
Why do we go for stored procedures?
What are the different types of joins in sql?
Define sql delete statement.
What do you think about pl/sql?
What are the benefits of stored procedures?
What is an oracle stored procedure?
What are commit, rollback, and savepoint?
what is the command line end user interface - mysql? : Sql dba
Define concurrency control. : Transact sql