How to minimize dependency failures occurring during the recompilation of a dependent subprogram?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

How to minimize dependency failures occurring during the recompilation of a dependent subprogram?

Rating:

During the recompilation of a dependent subprogram (procedure or function), the dependency failures can be minimized by following the below-mentioned guidelines:

  • Declare records by using the %ROWTYPE attribute.

  • Declare variables with the %TYPE attribute.

  • Perform queries with the SELECT * notation.

  • Include a column list with INSERT statements.


    • Rating:



    Other articles

    Click here to Article home

    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+

    Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g, 1Z0-040: Upgrade to OCA 10g Fundamentals I, Oracle Fundamentals II, Admin I, Oracle Admin II, PL/SQL CIW foundation    Photoshop ACE
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.
     
    HACKER SAFE certified sites prevent over 99.9% of hacker crime.