Interested to Buy Any Domain ? << Click Here >> for more details...
why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 10321 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
Is delete faster than truncate?
Define tables and fields in a database
how to calculate the difference between two dates? : Sql dba
Can we use pl sql in mysql?
What is right join sql?
What is cursor in pl sql?
tell me about various levels of constraint. : Sql dba
What are the two parts of design view?
when MSQL8.0 is in market
Describe sql comments?
What is clause in sql?
Can we create clustered index without primary key?
What are sql procedures?
Explain the components of sql?
Explain the savepoint statement.
