If commission is null then the text “Not Applicable” must be displayed, instead of blank space. How do I write the query?
select nvl(to_char(comm),'NA') from emp;
select nvl(comm,'NA') from emp;
select nvl(comm,NA) from emp;
None of the above