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

1 vote232 views1 answer
Database Queries
SQL
38 votes217 views4 answers
Count sql
SQL
0 vote211 views1 answer
Minecraft duping allowed servers
SQL
1 vote215 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote256 views1 answer
Select year from dual oracle
SQL
0 vote229 views1 answer
Change filed order in mysql
SQL
3 votes240 views1 answer
Create a table with an id in mysql
SQL
0 vote237 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote218 views1 answer
Mysql undo delete
SQL
5 votes214 views2 answers
Mysql date greater than 30 days
SQL