PL/SQL (MOSC)

MOSC Banner

Not a group by expression

edited Aug 9, 2013 3:33AM in PL/SQL (MOSC) 5 commentsAnswered ✓
I am trying as part of my select statement in a view creation to do the logic that if the budget name is like '%Budget% put the value B else if the budget name is like Forecast% but the value F else put A.

I am using the decode command and have the following:

SELECT p.period_name period,cc.segment1 company,cc.segment2 cost_center,cc.segment3 ACCOUNT,apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,3,cc.segment3)account_desc,( NVL (SUM (bal.period_net_dr), 0)- NVL (SUM (bal.period_net_cr), 0))period_balance,( NVL

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