A Query Builder model is created with Where conditions or calculated fields and the DML file is saved. Once DML file is reopened some of these conditions and calculated fields do not appear in Query Builder.
Query was rebuild again and saved as a SQL file. The SQL files was opened in Editor and the "Send to Query Builder" option was used. Again some of the Where conditions and calculated fields do not appear in Query Builder.
Toad does not report any error messages.
These Where conditions use IN, BETWEEN, IS NOT NULL and such Oracle functions.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center