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 votes108 views1 answer
Find tables with column name in sql
SQL
0 vote103 views1 answer
Sql transact create cursor with dynamic tables
SQL
1 vote144 views1 answer
Wordpress change url phpmyadmin
SQL
9 votes129 views6 answers
Oracle substring
SQL
3 votes108 views1 answer
Insert into table from another table mysql
SQL
13 votes114 views2 answers
Sqlite rename table
SQL
0 vote115 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote109 views1 answer
Show tables in cassandra cql
SQL
0 vote129 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote104 views1 answer
What is between keyword used for
SQL