First page Back Continue Last page Graphics

Using Parameterized WHERE Clauses


Notes:

Using Parameterized WHERE Clauses

If you have some, but not complete, information about the WHERE clause you want for a view object definition, you can dynamically set individual WHERE clause parameters in particular view object instances at run time.

To parameterize the WHERE clause in a view object definition, perform the following steps:

1. Open the view object editor.

2. Click the SQL tab in the editor, and under SQL Query, click Edit.

3. Enter a WHERE clause using parameters. You can just enter it or use Query Builder. Unless you are running the application against a non-Oracle database, you should use the Oracle Named binding style: ORDER_TOTAL > :Item1 + :Item2 If you are running the application against a non-Oracle database, you need to use JDBC-style parameters: ORDER_TOTAL > ? + ? In this case, the first ? is the first parameter, and the second ? is the second parameter. If you have used ?-style parameters, ensure that JDBC Positional is selected from the Binding Style list.