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
- 7897 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 is clustered and nonclustered index in sql?
Explain the insert into statements in sql?
what are all types of user defined functions? : Sql dba
What are tables and fields?
What are the two virtual tables available at the time of database trigger execution?
What is data definition language?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
what does the t-sql command ident_current does? : Transact sql
Can we alter stored procedure?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Why do we need sharding?
How to return multiple rows from the stored procedure?
what are all the different types of indexes? : Sql dba
What are different types of functions in sql?
how to extract a unit value from a date and time? : Sql dba
