How to insert a NOT EXISTS sub-query in the Query Builder (4228854)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to insert a NOT EXISTS sub-query in the Query Builder
Description

Options available in the Query Builder only show an EXISTS sub-query clause but I cannot find a NOT EXISTS option.
Cause

Feature does not exist in Query Builder tool.
Resolution

WORKAROUND:

Use the EXISTS sub-query option, then manually write in a 'NOT' before the EXISTS statement.

STATUS:

Enhancement Request ST66340 has been submitted to Development for consideration in a future release of Toad for Oracle.
Defect ID

ST66340

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title