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 producer123, Apr 12, 2018.

  1. producer123

    producer123 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    new york
    Hi,
    Why every one using function for calculations? why not procedure? what is main reason?
     
    producer123, Apr 12, 2018
    #1
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    775
    Likes Received:
    147
    Trophy Points:
    830
    Location:
    Russian Federation
    That elements have a functional differents at using.
    Note : At any langauge of programming.

    Some examples for Oralce:
    The FUNCTION always returns a value.
    The FUNCTION for SQL can not use DML.

    The PROCEDURE can not be used in SQL.

    What's your question?
     
    krasnoslobodtsev_si, Apr 13, 2018
    #2