How to use Select Exists in Oracle?

Question

What is the equivalent of the below SQL Query in Oracle?

SELECT CAST(
   CASE WHEN EXISTS(SELECT * FROM theTable where theColumn like 'theValue%') THEN 1 
   ELSE 0 
   END 
AS BIT)

I just want an oracle query where exists is used and it returns 0 or 1 like above.

Answer 1

The equivalent would be:

select count(*) 
from dual 
where exists (SELECT * FROM theTable where theColumn like 'theValue%')

Answer 2

This would show the same output. Just removed the CAST and added a FROM dual as Oracle doesn't allow queries with SELECT and without FROM:

SELECT 
   CASE WHEN EXISTS(SELECT * FROM theTable where theColumn like 'theValue%') 
     THEN 1 
     ELSE 0 
   END 
FROM dual ;

Tested at SQL-Fiddle