Interested to Buy Any Domain ? << Click Here >> for more details...
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='')
- 2 Answers
- 7909 Views
- I also Faced
- E-Mail Answers
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
What are the key differences between SQL and PL SQL?
How do I use google cloud in sql?
What is sql*loader?
What is clustered index sql?
How can you view the errors encountered in a trigger?
What are stored procedures in mysql?
What are the types of keys?
how to start mysql server? : Sql dba
What is the purpose of design view?
How to write a query to show the details of a student from students table whose
What is the difference between jpql and sql?
Do ddl statements need commit?
How many tables can a sql database have?
What is java sql connection?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
