PL/SQL (MOSC)

MOSC Banner

Case statement or how then?

in PL/SQL (MOSC) 4 commentsAnswered

Hi

I am in process of developing a package that will update late charges to customers. I am using this case statement as part of my select statment:

CASE

    WHEN profile.profile_class_id = 4040

    THEN profile.LATE_CHARGE_TERM_ID = 2001

    WHEN profile.profile_class_id != 4040

    THEN profile.LATE_CHARGE_TERM_ID = 5

    ELSE  null

    END AS late_charge_term_id


This is used in a select script and my aim is to display the profile.LATE_CHARGE_TERM_ID as 2001 when the profile.profile_class_id = 4040 and to display the profile.LATE_CHARGE_TERM_ID as 5 when the profile.profile_class_id != 4040.

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