Oracle EBS Query-by-Example – Query like a Pro

Tom GilpinOracle, Technical TipsLeave a Comment

abstract geometric colorful pattern

Knowing all of the options when querying in forms will help take users beyond average and toward ‘power user’ status. Master the use of query wildcards, and query operators as described below. Query Basics Query-by-Example is a simple three step process: While in a form, switch to query mode by selecting <F11> from the keyboard enter the criteria for the query execute the query by selecting <ctrl><F11> simultaneously from the keyboard   While performing step 2 (enter the criteria), with either wildcards or operators as shown in the tables below. Query Wildcards Query Operators In the examples below, the query … Read More