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 vote272 views1 answer
Snap craft
SQL
0 vote288 views1 answer
Hoq to import database source
SQL
0 vote303 views1 answer
.sql File Run in PSQL
SQL
0 vote284 views1 answer
How change the field place in mysql
SQL
0 vote278 views3 answers
Sql count condition
SQL
0 vote261 views1 answer
Sqlite referential integrity
SQL
40 votes366 views4 answers
PostgreSQL add column
SQL
0 vote276 views1 answer
Partitioning in oracle-base
SQL
0 vote276 views1 answer
Android sqlite get rows count
SQL
0 vote271 views1 answer
Mysql show create db
SQL