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

20 votes299 views1 answer
Get all table name in sql through php
SQL
20 votes268 views4 answers
Sqlite create table if not exists
SQL
5 votes286 views2 answers
Sql number columns
SQL
3 votes250 views3 answers
Mysqldump: couldn
SQL
1 vote276 views1 answer
Sql dcl
SQL
0 vote280 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
3 votes248 views1 answer
Oracle detect invalid password
SQL
3 votes288 views2 answers
Order by postgresql
SQL
0 vote271 views1 answer
Search In the Database using Text
SQL
0 vote288 views2 answers
Execute stored procedure without db set
SQL