SELECT FALSE|| TRUE AS val FROM DUAL ?? i m expexting true

Question

SELECT FALSE|| TRUE AS val FROM DUAL How will i get boolean result from this query... Suppose i have got result from False and true so that final result will true.

Jignesh Trivedi · Answer

Hi As per my knowledge || is concatenate operator. SELECT 'Jignesh' || ' ' || 'Trivedi' FROM dual; Result: 'Jignesh Trivedi' so I think you need to use OR operator. hope this will help you.