[SQL] How to replace null values with a text?

I need to display Employee last_name and their commission amount from employees table in Oracle SQL, but the condition is if it encounter NULL value I need to print "No Commission".
For the first part I wrote:

select last_name, commission_pct from employees;


But I am unable to get how to replace NULL values with "No Commission".

Continue reading...