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 vote150 views1 answer
How to move a column to different spot mysql
SQL
1 vote134 views1 answer
Primary key with prefix sql
SQL
0 vote138 views1 answer
Sql tabelle erstellen
SQL
0 vote150 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote150 views2 answers
Unique key
SQL
0 vote138 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote145 views1 answer
Oracle sql date summer time
SQL
3 votes171 views1 answer
Oracle detect invalid password
SQL
6 votes133 views3 answers
Update with inner join postgres
SQL
0 vote133 views1 answer
Enable outgoing remote MySQL access
SQL