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!

Inbuilt function for multiply.,?

Discussion in 'SQL PL/SQL' started by Vicky, Nov 19, 2015.

  1. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Hi all,

    Is there any inbuilt function in Oracle for Multiply, as like Sum.?

    Code (SQL):

    SELECT SUM(level) AS SUM FROM dual
    CONNECT BY level<=5;

    SUM                  
    -------
    15


    SELECT multiply(level) FROM dual
    CONNECT BY level<=5;

    ORA-00904: "MULTIPLY": invalid identifier
    00904. 00000 -  "%s: invalid identifier"
     
     
  2. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    I got something like exp(sum(ln(level))) instead of multiply(level).. Is tat one,.?
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    there is no such built-in functions
     
  4. VENKEY11

    VENKEY11 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    bangalore
    there is no in bulit functions