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

Explain architecture of sql server notification services?

981


What is t sql used for?

968


Explain the update statement in sql

914


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985


How to make a copy values from one column to another in sql?

978


What is sqlerrm?

880


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2447


Can we debug stored procedure?

953


what are the t string functions available in tsql? : Transact sql

944


What is sorting in sql?

889


Is subquery faster than join?

948


What is the current version of postgresql?

1003


How to create a menu in sqlplus or pl/sql?

1062


How many types of cursors supported in pl/sql?

1091


What does where 1/2 mean in sql?

1006