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 vote418 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote378 views1 answer
Running mysql from bash sc
SQL
1 vote349 views1 answer
Float precision in psql
SQL
0 vote375 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote370 views1 answer
Repeatable read trong sql server
SQL
0 vote413 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote364 views1 answer
Postgres can integer fields be negative
SQL
16 votes360 views4 answers
Ascending order mysql
SQL
0 vote355 views1 answer
Get rows from 1 table with other table empty mysql
SQL
3 votes324 views1 answer
Mysql UPDate with enner join
SQL