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
- 7651 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
Mention what does the hierarchical profiler does?
How can you load microsoft excel data into oracle? : aql loader
Which language is used in sql?
Determine if oracle date is on a weekend?
What is the clause we need to add in function body to return variable?
How to connect a sql*plus session to an oracle server?
how to calculate the difference between two dates? : Sql dba
What is trigger price?
Explain the uses of control file.
what is commit? : Sql dba
What are system versioned tables?
What is faster join or subquery?
how to present a past time in hours, minutes and seconds? : Sql dba
What is full join in sql?
how to get a list of all tables in a database? : Sql dba
