GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Programmatic Constructs
Go To First  |  Previous Question  |  Next Question 
 Programmatic Constructs  |  Question 5 of 13    Print  
What are the advantages of having a Package ?
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)



  
Total Answers and Comments: 3 Last Update: July 25, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 25, 2005 14:42:56   #1  
J Lehew        

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.
 
Is this answer useful? Yes | No
September 13, 2006 08:08:12   #2  
Pankaj Gauba        

RE: What are the advantages of having a Pac...
Main advantage is OVERLOADING of function and procedures
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 2Overall Rating: -2    
July 25, 2008 11:15:52   #3  
laxma823 Member Since: July 2008   Contribution: 3    

RE: What are the advantages of having a Package ?
pakage having more advantages
1)Modularity
2)Easily application dision

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape