Toad World® Forums

How to create the subquery of interest within the Actionable Query Property for SQL in Automation Designer

I am trying to create a actionable query but I am not able to get the right syntax

Steps I have followed:

  1. select radio button: SQL

  2. insert in the white box below: select * from table1;

  3. click on Run

Output: ORA-00936: missing expression

Note: Above the white box to write says: SELECT 'TRUE’FROM DUAL WHERE…

I have put this text also before my query and still is not working, I am sure I am missing some basics in the syntax. I am able to run the same query on a edit window in toad for the schema and instance I selected for the actionable query. I got to admit I don’t know much about the dual table shown in the query above, if somebody can write an example here of a working query and explain it a bit so I can take advantage of this feature in Toad. Thank you in advance :slight_smile:

ORA-00936: missing expression

Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.

Action: Check the statement syntax and specify the missing component.

So, according your case…

select * from table1;

When you connect to Oracle SQL*Plus with same user on the **same database as in Toad, ** can you perform that query as well?
Think not.

Cheers,
Damir