SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Decode and different data types

Eslam_ElbyalySep 2 2015 — edited Sep 2 2015

hi ,

i am trying to use the decode function like this

SELECT decode(:p_group_by_value, 2,rl.group_code , 3,r.relative_code , 4,r.REG_DATE, null)

and there is an error because inconsistent datatypes (4,reg_date) .

is there a way to avoid that error ? or a replacement for decode function ?

thanks in advance

This post has been answered by Jagadekara on Sep 2 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2015

Added on Sep 2 2015

14 comments

1,418 views