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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between stored procedure and packaged
procedure

Question Posted / sree


what is the difference between stored procedure and packaged procedure..

Answer / sanjeev verma

A Storeprocedure is a Set of transactionl SQL statements
which will do some operation. Storedprocedure is
precomplied . When we use sp's in our application it will
reduce network traffic because we need to just call the sp
from our appliaction by using the name of the sp and the
parameters, and no need of writing queries in the code.

A package is a collection of storedprocedures. A package
should have a declaration part and a body part. The
declaration part is used to declarte the stored procedures
and the body part is used to implement the storedprocedures.

Is This Answer Correct ?    9 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

how to shutdown mysql server? : Sql dba

0 Answers  

What is sql indexing?

0 Answers  

What is the primary use of normalization?

0 Answers  

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

What is a data manipulation language?

0 Answers  

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

why sql is used as interpreter frequently rather than a compile?

1 Answers  

What is NOCOPY?

6 Answers   DELL,

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

What is nosql vs sql?

0 Answers  

how would you get the current date in mysql? : Sql dba

0 Answers  

Is pl sql a programming language?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories