Variables can be embedded in the original SQL statement without pre-defining the data type and value. All variable names will be highlighted in red after the optimization process. SQL Optimizer will recognize declaration of variables either with or without a ":" (host variables) or "?" (parameter markers) sign. During optimization, run time or run result, the data type and value of the variables will require definition by using the Parameters window.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center