PL/SQL (MOSC)

MOSC Banner

Sum the time value against results for same object ids

edited Mar 28, 2013 3:12AM in PL/SQL (MOSC) 4 commentsAnswered
Hello Everyone,

I have scenario where I need to sum the time values against results for same object ids.

      object_id      result_id          value

       301                111                      0.1

     301                  112                     0.1

     301                  113                     0.2

     302                  114                    0.3

    304                  115                     0.1

    305                  116                    0.2

    306                 117                    0.3

i need a logic where all values aganist result_ids within same object_id will be summed and put under one object id.

Like, for object_id 301, the value would be 0.1+0.1+0.2 = 0.4 

Please advise!

Regards,

Saurav

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center