Oracle boolean to varchar

CREATE OR REPLACE FUNCTION BOOLEAN_TO_CHAR(STATUS IN BOOLEAN)
RETURN VARCHAR2 IS
BEGIN
  RETURN
   CASE STATUS
     WHEN TRUE THEN 'TRUE'
     WHEN FALSE THEN 'FALSE'
     ELSE 'NULL'
   END;
END;

Source: grepper.com

Similar codes

1 vote313 views1 answer
Db.Database.SqlQuery
SQL
0 vote639 views1 answer
Sql field equals multiple values
SQL
2 votes304 views1 answer
Coalesce sql
SQL
0 vote282 views1 answer
Every Derived yable must have its own alias
SQL
0 vote278 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
16 votes288 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote256 views1 answer
Sql python hwo to pass a list in paramerter
SQL
3 votes295 views1 answer
APEX elapsed time
SQL
0 vote262 views1 answer
Sql string contains case sensitive
SQL
5 votes273 views1 answer
Oracle nls parameters
SQL