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

What is the difference between unique and primary key constraints?

1071


What is an inconsistent dependency?

1046


What is the difference between Union and Union all. Which is faster.

1403


What is normalization in a database?

1159


What is tuple in sql?

1079


What is pl sql quora?

1167


Can you have a foreign key without a primary key?

955


What is blind sql injection?

1073


How to use sql*plus built-in timers?

1201


What is sqlcontext?

1085


What are sql ddl commands?

1093


What are pl/sql cursors?

1049


What is the difference between syntax error and runtime error?

1142


What does sign mean sql?

1113


Can we create table inside stored procedure?

955