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

8 votes323 views1 answer
Show mysql user table
SQL
0 vote318 views1 answer
Opensuse start MySQL
SQL
17 votes329 views6 answers
Get last record in sql
SQL
6 votes299 views1 answer
Phpmyadmin reset root password
SQL
0 vote322 views1 answer
Sql datediff db2
SQL
0 vote322 views1 answer
Restore backupfile discourse
SQL
0 vote333 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote406 views1 answer
Compress sql file database ubuntu
SQL
0 vote327 views1 answer
Java check if something is in mysql table
SQL
1 vote326 views1 answer
Get the User Name and Domain Name from an Email Address
SQL