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

1 vote269 views1 answer
Oracle enable job
SQL
0 vote251 views1 answer
Renombrar tabla mysql
SQL
0 vote246 views1 answer
Mysql command prompt date insert format
SQL
0 vote252 views1 answer
Mysql Error Code: 1005
SQL
1 vote259 views4 answers
Psql check tables command
SQL
0 vote324 views1 answer
Mysql get longest string in column
SQL
1 vote254 views1 answer
Oracle rolling back
SQL
0 vote225 views1 answer
Sql runnignsum
SQL
1 vote266 views1 answer
Postgres killing connections on db
SQL
0 vote261 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL