Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between stored procedure and packaged
procedure
- 1 Answers
- 11618 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 |
wtite down triggr not any entry on Sunday
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
Is sql harder than python?
What are packages in pl sql and also explain its advantages?
what is variable in package specification
Can we write dml inside a function in sql server?
How do you create a unique index?
What is the best partition size for windows 10?
suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary
What is procedure function?
What is spool?
How are sql commands classified?
-
Oracle (3253) - 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)
