Exists in WHERE condition

@haritha.waidyaratne What is the result produced by the method call?

I suspect it might trigger a "Too Many Rows" exception rather than returning a value of True or False. Please check !

Hi Buddhika,

Sure will check it in detail and get back to you.

Thanks many for the suggestion.

Kind regards,
Haritha

Hi @haritha.waidyaratne 

Oracle doesn’t have the support for BOOLEAN in comparison rules. Exists returns a Boolean and therefore you cannot use it in a condition expression.

Check here for more details

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Type-Comparison-Rules.html

Hope it helps.

Damith

Hi,If you explain in detail the query you want to make, I can help you in a different format.

Hi Alpenen,

Thanks for offering to help. I have already accomplished the task. My question was why Exists() doesn’t work as expected.

Kind regards,