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!

Problem with a sp

Discussion in 'General' started by alvamabel2018, Apr 21, 2018.

  1. alvamabel2018

    alvamabel2018 Starter

    Likes Received:
    Trophy Points:
    Hồ Chí Minh
    Hi All,

    I am new to using oracle and want to write a SP which does the following

    If Ex_key is null and END DATE is not null and not of STDATE +1 and PST in (R or RR) then
    WT = CASH/SUM OF CASH for same Ex-Key
    MV = Ex_key MV * WEIGHT
    N = Ex_key N * WIEIGHT

    I am not sure how to get started with

    Main pointers I need on are as below

    how to write this SP.
    How to How to get the sum of cash for same Ex_key
    how to get the Ex_key MV and Ex_key N

    Please help as I have to deliver this end of this week and I do not know how to even start this.
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    Ask your instructor for assistance; he or she knows what material you have covered and can direct you properly.