Query Parameters in Code Mode

In query designer, the query parameter can be created in both design and code mode. The following sections describes the steps to create query parameters in query mode.

Create query parameter in code mode

1. Click on the switcher in query designer toolbar, to switch to the query mode.

2. Specify the query in the text area, the query specified in the below snap returns the list of Invoice Details from the REP_PROFITMARGIN database.

3. Now, add the following WHERE clause at the end of the query to create a query parameter.

4. WHERE (("DEVROUNDED_REPORTS"."REP_PROFITMARGIN"."ORDERDATE" BETWEEN TO_DATE(@REP_PROFITMARGIN_ORDERDATE, 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE(@REP_PROFITMARGIN_ORDERDATE1, 'MM/DD/YYYY HH24:MI:SS')))

5. Click Save and Exit.