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 / rajesh venati

A Procedure is a Named Pl/Sql program. Procedures are used
for to perform a particular task. Overloading concept is not
allowed in standard alone procedures.

Then go for Packages, package is grouping the collection of
database objects like procedures, functions, type, variable,
cursors and exception etc... Here overloading concept is
valid, we can define same name for database objects with
different type of parameters or data types.....

I believe this is useful.................

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all types of user defined functions?

1073


What is clause?

1151


What is record variable?

989


What is pl sql and why it is used for?

1113


What is difference between sql function and stored procedure?

1004


Is there a way to automate sql execution from the command-line, batch job or shell script?

971


What is loop in pl sql?

1038


Can we use pl sql in sql server?

1082


what is table? : Sql dba

1063


Are sql connections encrypted?

1023


What is sql used for?

1125


What are the different type of joins in sql?

956


Is sql scripting language?

1052


What is user defined functions?

982


Difference between truncate, delete and drop commands?

1082