is any other way to replace query result null value with a text

Question

I am using below statement but i got error.
ALTER TABLE XXXtable
ADD xxx_name varchar2(50) not null;

error message:
ORA-01758: table must be empty to add mandatory (NOT NULL) column

Answer 1

SQL> Set NULL ‘N/A’
to reset SQL> Set NULL ‘’