Setting a Default Column Value in Select Statement for TO_CHAR

Question

Im trying to assign a default column value for a TO_CHAR function.

 SELECT
 '1' AS TO_CHAR(N_NAME)

I keep getting the error "FROM keyword not found where expected". Can anyone assist?

Answer 1

SELECT '1' AS "TO_CHAR(N_NAME)"
FROM YourActualTableName;