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
- 7793 Views
- I also Faced
- E-Mail Answers
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 |
Explain the difference in execution of triggers and stored procedures?
Are subqueries better than joins?
What is sql data?
What is parameter substitution in sql?
How will you distinguish a global variable with a local variable in pl/sql?
Give which cursor is better for better performance means type of cursors?
what is the difference between a web-garden and a web-farm? : Sql dba
What is the size of partition table?
How do you modify a column in sql?
What do you understand by exception handling in pl/sql?
What is sqlcommand?
Can we use rowid as primary key?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
