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

Similar codes

0 vote220 views1 answer
View acl table oracle
SQL
9 votes231 views1 answer
Oracle get table schema
SQL
0 vote230 views1 answer
How to to get current date in sql
SQL
0 vote224 views1 answer
Set mysql socket file docker windows
SQL
3 votes220 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote235 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
19 votes216 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote242 views1 answer
How to find lowest in sql
SQL
0 vote214 views1 answer
Rollback to name in sql
SQL
0 vote253 views1 answer
Mysql bash execute sql file
SQL