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 difernece between named and anonymous pl/sql
blocks??

Answer Posted / purushotham

Named pl/sql blocks are nothing but procedures.
procedures are compiled and stored in the database and
a user can call the procedure when required.
whereas anonymous are unnamed pl/sql blocks that will be
available for the time that is executed and it will not the
stored in the Database.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a procedure in a package be overloaded?

1045


Are null values same as that of zero or a blank space?

1028


What is a delimiter in sas?

1057


What is a variable in sql?

1001


How many clustered indexes can you have?

975


What is #table in sql?

1101


What is the use of prepared statement?

1025


What are variables in pl sql?

1167


What are the different datatypes available in PL/SQL?

1085


What are operators available in sql?

1047


Explain the significance of the & and && operators in pl sql.

1009


What is recursive join in sql?

1026


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

1269


What is an emotional trigger?

1005


What is snowflake sql?

1074