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 vote108 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote85 views1 answer
Java spring boot connect to sql server
SQL
0 vote98 views3 answers
Fetlife
SQL
0 vote107 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote144 views1 answer
Sql alchemy escape ; in insert statement
SQL
2 votes101 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote108 views1 answer
Sqlite commands
SQL
0 vote167 views4 answers
Stored procedure sql
SQL
0 vote59 views1 answer
Sql count how many times a value appears
SQL
0 vote106 views1 answer
Postgres where
SQL