Pl sql case

Oracle case

SELECT product_id, product_type_id,
  CASE product_type_id
    WHEN 1 THEN 'Book'
    WHEN 2 THEN 'Video'
    WHEN 3 THEN 'DVD'
    WHEN 4 THEN 'CD'
    ELSE 'Magazine'
  END
FROM products;

Source: mastertraining.com.br

Pl sql case

CASE [ expression ]

   WHEN condition_1 THEN result_1
   WHEN condition_2 THEN result_2
   ...
   WHEN condition_n THEN result_n

   ELSE result

END

Source: techonthenet.com

Similar codes

36 votes199 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote195 views1 answer
Mysql add to number
SQL
0 vote160 views1 answer
Login phpmyadmin without password
SQL
1 vote199 views1 answer
Sqlite3 read only
SQL
1 vote280 views1 answer
How to select random rows from a table
SQL
2 votes200 views2 answers
Postgres add column integer
SQL
1 vote201 views1 answer
SQL Integer devision
SQL
0 vote189 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote192 views1 answer
Test the postgresql db connection
SQL
0 vote190 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL