NVL2

1
SELECT
2
  customer_name,
3
  email,
4
  NVL2(email, 'Has Email', 'No Email') as email_status
5
FROM customers;

1
SELECT
2
  salesperson,
3
  manager_id,
4
  NVL2(manager_id, 'Standard Rate', 'Manager Rate') as commission_type,
5
  NVL2(manager_id, 0.05, 0.10) as commission_rate
6
FROM sales_team;

1
SELECT
2
  product_name,
3
  discount_percent,
4
  NVL2(discount_percent,
5
    CONCAT(discount_percent::VARCHAR, '% OFF'),
6
    'Regular Price'
7
  ) as display_text
8
FROM products;