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 vote196 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote270 views1 answer
Continue in sql
SQL
0 vote198 views1 answer
Nth max in my sql
SQL
0 vote201 views2 answers
How to know the character set of an oracle databes
SQL
0 vote221 views1 answer
Sql delete dastabase
SQL
3 votes220 views2 answers
See mysql users ubuntu
SQL
0 vote202 views1 answer
Postgres where
SQL
0 vote213 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote206 views1 answer
Mariadb LOAD DATA INFILE
SQL
28 votes219 views4 answers
Mysql delete database
SQL