1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

functions

Discussion in 'SQL PL/SQL' started by bnramesh8, Sep 2, 2014.

  1. bnramesh8

    bnramesh8 Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    Why every one using function for calculations? why not procedure? what is main reason?
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Who told that every one using function for calculations?

    Few people are using. Because We can use functions in a SELECT statement but we cannot use procedures similarly.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    Everything depends on a specific situation.

    Fox example : procedure can't be used in SQL SELECT.

    See also :
    function
    procedure