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

0 vote191 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote200 views2 answers
Psql commande \gset
SQL
0 vote202 views1 answer
How to create a table in sql stack overflow
SQL
0 vote198 views2 answers
Timing sql queries
SQL
0 vote197 views1 answer
Sql server datetime
SQL
0 vote192 views1 answer
Sql convert float to string
SQL
1 vote157 views1 answer
Restart identity postgresql
SQL
0 vote204 views1 answer
Sql last time database was accessed
SQL
3 votes208 views1 answer
Oracle drop user
SQL
1 vote198 views1 answer
Postgres power
SQL