Need a receomendation for how to implement this in TOAD
I have a query in query builder that uses about 10 tables. One of the variables needs to populate from case statement and a sub query for example
CASE WHEN varx IS NOT NULL THEN 1 WHEN varx IS NULL AND vary IN (SELECT varz FROM t2) THEN 2 ELSE 1000 END
Also is there an advanced query builder tutorital that I can reference?