Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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='')

Question Posted / v karthik.

Answers were Sorted based on User's Feedback



Create a procedure to delete certain records from a table and display the total number of records ..

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

Create a procedure to delete certain records from a table and display the total number of records ..

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

Post New Answer

More SQL PLSQL Interview Questions

What are the query optimization techniques?

0 Answers  

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

What are the string functions in sql?

0 Answers  

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

How to order siblings in oracle hierarchy queries?

0 Answers  

How many types of keys are there in sql?

0 Answers  

Does indexing improve query performance?

1 Answers  

Is record in pl sql?

0 Answers  

What is the difference between join and natural join?

0 Answers  

Can we use commit inside a trigger?

0 Answers  

What is the difference between cross join and natural join?

0 Answers  

What is materialised View?

2 Answers   IBM,

For more SQL PLSQL Interview Questions Click Here
Categories