mercredi 27 mai 2015

One line IF condition in PL/SQL

It's possible to write one line if's in pl/sql? I'm just curious.

I want to write this snippet:

IF ( i.DECISAO_AT = 'S')
THEN 'PA'
ELSE 'I'
END IF;

And I want to know if it's possible to write it in one line, just like java. Like this:

IF ( i.DECISAO_AT = 'S') ? 'PA' : 'I' ;

Thanks!

Aucun commentaire:

Enregistrer un commentaire