SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

CASE expression in Oracle SQL statement

Let's think we write a select statement and would like to DECODE (on Oracle database) on a column:

DECODE(bew.bewart_tid, 'GDL', 'Grenzüberschr. Dienstl. aus EWR Raum' ,bewart.bezeichnung) col_alias

Now you'd like to decode an additional value on the same column. This could result in a not-well-readable DECODE expression.
Better you try to use the CASE expression:

, case when bew.bewart_tid = 'GDL' then 'Grenzüberschr. Dienstl. aus EWR Raum'
when bew.bewart_tid = 'GDLA' then 'Grenzüberschr. Dienstl. aus EWR Raum'
else bewart.bezeichnung
end col_alias

This is a well-formed and well-readable SQL statement.

Bookmark It