save up to 40%

What are the advantages of using user-defined functions in SQL expressions?

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.

What are the advantages of using user-defined functions in SQL expressions?

Rating:

SQL expressions or statements can reference PL/SQL user-defined functions. Wherever a built-in SQL function can be placed, a PL/SQL user-defined function can be placed as well. Using the user-defined functions in SQL expressions offers the following advantages:

  • It permits calculations that are too complex, awkward, or unavailable with SQL.

  • It increases data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application.

  • It increases efficiency of queries by performing operations in the query rather than in the application. For example, the performance is enhanced when a user-defined function is used in the WHERE clause to filter data, as opposed to filtering the data in the application.

  • It manipulates new types of data (e.g., latitude and longitude) by encoding character strings and using functions to operate on the strings.


    • Rating:



    Other articles

    Click here to Article home

     
    uCertify.com | Our Company | Articles | Privacy | Security | Contact Us | News and Press Release | uCertify India
    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 CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.