Inbuilt function for multiply.,?

  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:
    778
    Likes Received:
    149
    Trophy Points:
    830
    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