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 benefit of foreign key?

1013


Does inner join remove duplicates?

932


Determine if oracle date is on a weekend?

1033


Does user triggers have entry for trigger with compilation errors?

1024


Explain the types of joins in sql?

1025


What is the maximum size of sqlite database?

1098


What is normalization in sql?

1004


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1027


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1258


What is data types in sql?

995


What is the difference between delete, truncate and drop command?

1131


What are the two characteristics of a primary key?

965


how to enter numeric values as hex numbers? : Sql dba

1055


What is mdb stand for?

1003


what are the nonstandard string types? : Sql dba

1125