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
In what condition is it good to disable a trigger?
What is pl sql quora?
Why do we use sqlite?
What is trigger in pl sql with examples?
How to add, remove, modify users using sql?
When is the update_statistics command used?
What is set serveroutput on?
What is a table?
What is procedure and function?
What is a file delimiter?
How many commands are there in sql?
What are the parts of a basic sql query?
What is sp_helptext?
What is a sql select statement?
Which are the different character-manipulation functions in sql?