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

What is the difference between anonymous block and named
block or stored procedure?

Answer Posted / kavitha

An anonymous block is a pl/sql block that appears in your
application and is not named and stored in your database.

A stored procedure or a named block is a pl/sql block that
oracle stores in the database and can be called by name
from any application

Is This Answer Correct ?    41 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is left join same as inner join?

1211


Which join is like inner join?

1083


What is sql clause?

1088


explain mysql aggregate functions. : Sql dba

1024


How is pl sql different from sql?

1135


What is rowid in sql?

1048


What is the maximum rows in csv?

975


What is oracle and pl sql?

1154


what is a constraint? Tell me about its various levels. : Sql dba

1043


Can a procedure in a package be overloaded?

1096


How do you modify a trigger?

977


What programs use sql?

1082


Write a query to find the names of users that begin with "um" in sql?

1038


What is auto increment in sql?

1171


What is the maximum size of sqlite database?

1147