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...

How to execute multiple sql statements in a single annonymous
block irrespective of the sql statement result?

Answer Posted / gourav joshi

hi,
For eg u want to insert 3 data at a same time so u can use
annonyoums block for eg emp_id,Name,Salary u want to insert
data in a table u can use this annoynomous blck

Begin
Insert into table name values(1, 'gourav',2000);
Insert into table name values(2, 'joshi',6000);
Insert into table name values(3, 'ram',4000);
end;

then execute

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you select unique values in sql?

997


What is difference between joins and union?

1117


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1338


What is oracle sql developer?

1037


What is linq to sql?

1129


Explain the uses of a database trigger?

1035


What is sql and its types?

1174


what are the security recommendations while using mysql? : Sql dba

1111


How do I use google cloud in sql?

1082


How is data stored on a disk?

1016


How to fetch alternate records from a table?

1224


What is record type in pl sql?

982


Explain autonomous transaction.

1152


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

969


What is sql query limit?

970