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
- 7914 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 |
What is AUTH_ID and AUTH_USER in pl/sql ?
what is the difference between undefined value and null value? : Sql dba
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
Is primary key is clustered index?
What is bind reference and how can it be created?
What are the popular database management systems in the it industry?
How much does sqlite cost?
What is a mutating table and a constraining table?
what is the purpose of update command in oracle?
What are the different parts of a package?
How do you identify a primary key?
What are dml commands?
-
Oracle (3253) - 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)
