How to use BOOLEAN type in SELECT statement

by

You can definitely get Boolean value from a SELECT query, you just can’t use a Boolean data-type.

You can represent a Boolean with 1/0.

CASE WHEN (10 > 0) THEN 1  ELSE 0 END (It can be used in SELECT QUERY)

SELECT CASE WHEN (10 > 0) THEN 1  ELSE 0 END AS MY_BOOLEAN_COLUMN
  FROM DUAL

Returns, 1 (in Hibernate/Mybatis/etc 1 is true). Otherwise, you can get printable Boolean values from a SELECT.

SELECT CASE WHEN (10 > 0) THEN 'true' ELSE 'false' END AS MY_BOOLEAN_COLUMN
 FROM DUAL

This returns the string 'true'.

More Related Contents:

  1. Is it possible to output a SELECT statement from a PL/SQL block?
  2. Using ‘case expression column’ in where clause
  3. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  4. How to use Alias in Where clause? [duplicate]
  5. Merging two tables in SQL [closed]
  6. Splitting string into multiple rows in Oracle
  7. What is the string concatenation operator in Oracle?
  8. Using an Alias in a WHERE clause
  9. Pivoting rows into columns dynamically in Oracle
  10. Concatenate results from a SQL query in Oracle
  11. How can you tell if a value is not numeric in Oracle?
  12. passing table and column name dynamically using bind variables
  13. SQL error “ORA-01722: invalid number”
  14. Selecting the second row of a table using rownum
  15. Is there any way to flush output from PL/SQL in Oracle?
  16. ORA 00904 Error:Invalid Identifier
  17. Update with Join query in Oracle
  18. How to count the number of occurrences of a character in an Oracle varchar value?
  19. PLSQL Insert into with subquery and returning clause
  20. Is it possible to query a comma separated column for a specific value?
  21. What does the colon sign “:” do in a SQL query?
  22. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  23. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  24. Advice Using Pivot Table in Oracle
  25. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  26. How to handle optional parameters in SQL query?
  27. How to check if a column exists before adding it to an existing table in PL/SQL?
  28. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  29. Subtracting Dates in Oracle – Number or Interval Datatype?
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment