SQL editor helps you to write queries. Use CTRL+SPACE for helper.
If you choose tabe/view in field of block than you can writte only where statement, ... or you can write your own SQL statement. In tat case the order of variables in SQL must be the same like in varibles on block.
You can create dynamic SQL with using ON_SELECT trigger. Afther prepared SQL statement in string you must call:
open c__ for sql_statement; -- (pl/sql OPEN-FOR Statement)
Go back to [Documentation]