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 vote189 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
1 vote189 views1 answer
Order by oracle
SQL
3 votes173 views3 answers
Mysql get table size
SQL
0 vote164 views1 answer
How to connect to mysql in ef 6
SQL
1 vote175 views1 answer
Sql server locks
SQL
0 vote170 views1 answer
Difference between 2 query results sql server
SQL
3 votes212 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote179 views1 answer
Sql last 7 days
SQL
0 vote185 views1 answer
Watch mysql command line
SQL
31 votes186 views3 answers
SQL Server change column data type
SQL