Recompile package body after recompiling package requirement
In which circumstance should you recompile the package body after recompiling the package requirement?
Expert
Recompile the package body after recompiling the package requirement:
1. Changing the argument list of one of the constructs package
2. Any modification made to one of the package constructs
3. Any of SQL statement modification made to one of the package constructs
4. Eliminating a local variable by the DECLARE section of one of the package constructs.
Describe the difference between a regular sub query and a correlated sub query?
Elucidate what are the basic requirements to join two sources in the source qualifier?
Describe briefly the difference between pessimistic locking and optimistic locking?
Explain the four kinds of indexes?
State the different steps of data warehouse design process.
What is Datadriven?
Briefly describe time series algorithm in data mining?
What are the techniques in which an Oracle database can be created?
Which technique is used in the BCA?
Write a short on the six database functions which occur during the systems development life cycle?
18,76,764
1955393 Asked
3,689
Active Tutors
1416527
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!