why we go for package? what are the advantages of using
instead of seperate procuderes or functions
Answer Posted / aravinda
package is collection of logically related pl/sql types
,items, subprograms. packages have following advantages over
procedures and functions.
Modularity, easy to design applications, information hiding,
added functionality and best performance.
we can declare global variables in packages which are valid
across application.
without invalidating the package we can modify the package body.
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What do you mean by “trigger” in sql?
What is pessimistic concurrency control? : Transact sql
What is a stored procedure in sql with example?
How do you delete a table?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is parallel hint?
What is a nested table in word?
What do you mean by stored procedures?
What is composite primary key in sql?
Can I join the same table twice?
What is difference between inner join and cross join?
What is data manipulation language?
How do I find duplicates in the same column?
What is the difference between function and procedure in pl/sql?
What do you understand by exception handling in pl/sql?