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
- 7627 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 on delete restrict?
Can you create a table with Primary Key not as the clustered index.
what is self join and what is the requirement of self join? : Sql dba
what is the difference between truncate and drop statements? : Sql dba
function can return value ,procedure also return value through out parameter then what is the difference?
What's the difference between a primary key and a clustered index?
What is cursor status?
What is trigger with example?
Define SQL and state the differences between SQL and other conventional programming Languages?
what is self-join? : Sql dba
Differentiate between pl/sql and sql?
Why is sharding used?
-
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)
