GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Programmatic Constructs

 Print  |  
Question:  
What are the advantages of having a Package ?

Answer:
Increased  functionality  (for  example,global  package  variables  can  be declared  and  used  by  any proecdure in the package) and performance (for example  all  objects  of  the package are parsed compiled, and loaded into memory once)


August 08, 2005 14:42:56 #1
 J Lehew   Member Since: Visitor    Total Comments: N/A 
RE:
What are the advantages of having a Package ?
 
A package allows grouping of similar procedures. This is extremely important when working on a system with 500 stored procs. Also it allows some procedures to be made public and private and common variables and structures can be defined at the package level instead of inside each procedure.
     

 

Back To Question