I’m new to this forum and only somewhat familiar with some of the TOAD features. IE Toad Newbie and SQL Newbie.
I am using Toad for Oracle 184.108.40.206 and am stuck with the if…then…else syntax.
I have already created a User Variable in the script and started with a default value. Now I want to change the value associated with that user variable based on the result of a query (or some other logical option)
Options such as
- Table exists
- Rows returned from a query > 0
- Query result (single row, single column output)
Would appreciate some insight. I really like the automation designer but the folks I work with do not use it, so they can’t really answer my questions.
thanks in advance