In this post you'll learn how to
Specify any condition in Enter query mode of Oracle Forms. Whenever enter_query command executes Oracle Forms comes to Enter Query mode and in so mode you can specify some Crite Ria to filter the records and after the If you execute query using Execute_query Command then the records would is fetched based on this condition you specified.
Enter_query Built-in Usage Example:
Begingo_block (' Yourblock ');Enter_query; End;
The below is the screen shot from which records would being filtered in this example.
Note You can specify the search condition if Oracle Forms is in Enter Query Mode. The following is some search criteria Examples:search only those records where EMP Name containing AR specify%ar% in EMP Name column to fetch the records where AR exists in EMP Name.Result:Search only those records where second letter of EMP Name is lspecify one underscore for first any letter and then l% eg. _l%result:search only those records where Hire date was greater than 01st OCT 2015Specify greater than sign and the date in Single Quotes:resultsearch only those records where Salary are greater than 5000Specify greater than sign and the value eg . > 5000results:search only those where Job was equal to clerk and Salary was less than 4000Specify clerk in Job column and Less than sign and the value of Salary column you can also specify = sign and value in a single quote in Job column eg. = ' Clerk ' Result:
Enter Query Mode Search Tricks Using enter_query built-in in Oracle Forms
