Online Documentation for SQL Manager for Oracle

Query parameters


Both Query Data and Design Query support parameters usage inside the query text. A parameter is a kind of variable for which a value can be specified just before the query execution. In the query text the parameter should appear as an identifier with a colon (':') at the beginning, e.g.

 

SELECT * FROM MYTABLE WHERE ID = :param1;

 

Note: The Allow using of parameters in query text option should be checked on the Tools page of the Environment Options dialog for this feature to be enabled.