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  >  Database

 Print  |  
Question:  Size of Oracle package

Answer: “Bigger the size of a Oracle package, the better”. Do you agree? Justify.


September 09, 2009 00:37:55 #1
 dhiren21   Member Since: September 2009    Total Comments: 3 

RE: Size of Oracle package
 
No - I do not agree
Functionality depends..
What are you trying to do in a
package depends a lot...
A Package can call Views, Functions and Triggers, Update, Insert, Delete..


Purpose of a Package, For Eg..
If you create a Month End Package for a Co.
It Includes the Transaction Rollback, Commiting the Transactions, Updation, Locking the Transactions, Insertions, Deletion.
so it depends on a Package.


     

 

Back To Question