Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between stored procedure and packaged
procedure
- 1 Answers
- 11398 Views
- Google, Infosys, I also Faced
- E-Mail Answers
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 |
Is drop table faster than truncate?
Can a table contain multiple foreign key’s?
What is null in pl/sql?
what is bulk bind
What is a composite primary key?
What is the difference between sql/pl-sql/embeded sql?
What is scalar function?
Explain unique key in sql.
When should I use nosql database?
how to get a list of all tables in a database? : Sql dba
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
Explain character-manipulation functions?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
