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 difference between procedure and
packages

Answer Posted / kanchan kumari

procedure is named pl/sql block which is used by
programmer to perform any task these type of block exist in
database physically.

package is also named pl/sql block which is associated
with pl/sql variable, view, sub programs.
package can't be invoked
in other word we can say that package can contain more than
one procedure, function etc.but procedure can't

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum number of columns in sql table?

1169


How can you know that statistics should be updated?

1077


Why do you partition data?

1016


Does sql full backup truncate logs?

1014


Can you selectively load only those records that you need? : aql loader

1046


What is an inner join sql?

1026


What are the two types of cursors in pl sql?

1076


What is pivot in sql?

909


Why is pl sql needed?

932


Is sqlexception checked or unchecked?

968


What is application trigger?

994


Is sql between inclusive?

1127


What is the use of index in hive?

1005


Can we insert in sql function?

1081


what does it mean to have quoted_identifier on? : Sql dba

1144