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 vote183 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote164 views1 answer
IS THEre any difference between using default and := in plsql
SQL
2 votes177 views3 answers
Sql function
SQL
0 vote175 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote176 views1 answer
Migrations.RunSQL
SQL
3 votes156 views1 answer
Sql select all
SQL
0 vote171 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
2 votes178 views1 answer
Scaffold npgsql net core
SQL
1 vote163 views2 answers
Populate sql table with random data
SQL
0 vote251 views2 answers
Mysql insert rows to another database
SQL