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 vote115 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote136 views1 answer
Trigger stock phpmyadmin
SQL
0 vote121 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
5 votes113 views1 answer
Sort order on two columns sql
SQL
0 vote115 views1 answer
Datetime postgres typeorm
SQL
2 votes110 views1 answer
Oracle sql concatenate results into string
SQL
0 vote121 views1 answer
Add computed column to table sql server
SQL
0 vote109 views1 answer
Select top 3 sql
SQL
1 vote110 views1 answer
Scaffold mysql database
SQL
1 vote115 views1 answer
Mysql best tutorial for beginners
SQL