Oracle Forms (MOSC)

MOSC Banner

Oracle Forms querying strategies.

in Oracle Forms (MOSC) 2 commentsAnswered
The text in italics below is taken from Querying Strategies in Oracle Forms Document 9724.1. 
I am trying to find out if this method of advanced querying is still available in 
Forms 12.2.X or has it been deprecated? 
I can't find any other reference to this querying strategy other than Doc 9724.1


Method 2: Using the & Sign
--------------------------
1.  Put the form in the Enter Query mode.

2.  Navigate to the empno field.  Enter: &

3.  Press the execute key (as suggested by the message line).

    This displays a Query Where dialog box where you can type in any complex condition that you want.

4.  In the Query Where dialog box, enter:  ename LIKE 'S%' AND sal > 5000

5.  Follow the instructions on the message line again to execute the query.

    You have now used a powerful tool that helps you define complex

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center