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

7 votes302 views4 answers
How to reset the identity column in sql server
SQL
3 votes356 views2 answers
Oracle sql first day of month
SQL
0 vote321 views1 answer
Mariadb number format
SQL
0 vote327 views1 answer
What is between keyword used for
SQL
1 vote313 views1 answer
Create temporal table in sql
SQL
49 votes402 views6 answers
Mysql add column to table
SQL
0 vote338 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote359 views1 answer
Table structure in sql
SQL
0 vote306 views1 answer
Grant access on table in oracle
SQL
0 vote322 views1 answer
How to check xampp mysql password
SQL