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 vote157 views2 answers
Replace text in sql
SQL
1 vote184 views1 answer
Psql search table
SQL
0 vote146 views1 answer
Mysql workbench indent formatting
SQL
1 vote183 views2 answers
Limit sqlserver
SQL
0 vote200 views1 answer
Mysql row generator
SQL
16 votes157 views2 answers
Sql exists
SQL
0 vote159 views1 answer
Sql reverse order of results
SQL
0 vote167 views1 answer
Sum sqlserver
SQL
0 vote156 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote172 views1 answer
Postgres grep entire database
SQL