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

4 votes332 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote347 views1 answer
Oracle query archive mode
SQL
0 vote341 views1 answer
Convert int to varchar sql
SQL
0 vote345 views1 answer
Alter check command
SQL
5 votes346 views1 answer
Oracle asynchronous update
SQL
0 vote345 views1 answer
Get initials name in sql
SQL
0 vote327 views1 answer
Find all tables where column name exists oracle
SQL
0 vote386 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote323 views1 answer
Mysql jdbc timezone
SQL
0 vote363 views1 answer
Database schema for mcqs type exam in sql
SQL