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 function

user10274093Nov 16 2015 — edited Nov 17 2015

Hi,

on 11.2.0.4,

I have :

SQL> select code, decode(code, 'BD','Jeuness','INF','adulte','fff') from genres;

CODE DECODE(

----- -------

BD fff

INF fff

POL fff

REC fff

ROM fff

THE fff

Why it can not transforme BD to Jeuness and INF to 'adulte' ?

Thanks.

This post has been answered by RakeshChowdary Paleti on Nov 17 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2015

Added on Nov 16 2015

6 comments

486 views