PL/SQL Decode

Oracle PL/SQL Decode Example

Select  o.id, c.name, o.amount,

decode (o.amount, 	1200, 'Very Low',
					6000, 'Low',
					45000,'Good',
					60000,'Very Good'
					
) as decode_example    
      
From offers o,

customers c

Where o.customer_id = c.customer_id   

Order By 3