oracle select true if not null

Question

I have to select true in a variable when a field is not null, my attempt is this but does not compile, do you have a working solution?

        SELECT  CASE blob_data WHEN NULL THEN FALSE ELSE TRUE END
          INTO v_blob_found
          FROM docs dd
         WHERE dd.id=my_id

SQL, whether it's a `select` or a `select into` statement, does not support Boolean literals. In this situation `TRUE` or `FALSE` will be treated as identifiers, thus `..does not compile` . — Nick Krasnov, Aug 12 '14 at 08:37

score 3 · Answer 1 · answered Aug 12 '14 at 08:35

3

You can try somthing like this:-

SELECT  CASE WHEN blob_data IS NULL THEN 'FALSE' ELSE 'TRUE' END
INTO v_blob_found
FROM docs dd
WHERE dd.id=my_id

answered Aug 12 '14 at 08:35

Ankit Bajpai

Can you cast it like SELECT BOOLEAN(CASE WHEN blob_data IS NULL THEN 'FALSE' ELSE 'TRUE' END) ? – Luca C. Aug 18 '14 at 09:52
Well, sorry but no IDEA. – Ankit Bajpai Aug 18 '14 at 10:24

1 Answers1