Oracle Notations and Short Cut Keys

List of Values

Using the List of Values simplifies data entry.  There are multiple ways to search through a List of Values.

·         Type the first character(s) of a value to reduce the list.

·         Enter search criteria; then click [Find].

·         Scroll through the list and select the value.

Format

·         Date format:  DD-MON-YYYY.

Notations

·         (N) = Navigator

·         (M) = Menu

·         (T) = Tab

·         (B) = Button

·         (I)= Icon

·         (H) = Hyperlink

·         (ST) = Sub Tab

·         (Drop Down) = DropDown List

Example:

(N) People > Enter and Maintain

(M) View > Query By Example > Enter

Short Cut Keys

<F11>	Enter Query
<Ctrl><F11>	Execute Query (Refresh screen)
<F4>	Cancel Query
<F12>	Count Query
<Ctrl><S>	Save (Commit)
<Ctrl><L>	List of Values
<Shift><F5>	Duplicate Field from Above
<Shift><F6>	Duplicate Record from Above
<F5>	Clear Field
<F6>	Clear Record
<F7>	Clear Block
<F8>	Clear Form
<Ctrl><Up>	Delete Record
<Ctrl><Down>	Insert Record
<Ctrl><U>	Update Record
<Shift><Ctrl><E>	Display Error
<Ctrl><E>	Edit
<Shift><Tab>	Go to Previous Field
<Tab>	Go to Next Field

Query vs Find

Query Mode		Find Mode
Menu bar, <F11>		Menu bar, Toolbar
Existing Window		Find Window
Wildcards		List of Values
Query Count		No Find Count

Query Mode – Searches the database

·         Set search parameters for the query in the existing window to narrow the search.

·         When using wildcards, use any query operators to narrow the search.

·         Check to see how many records match the criteria before retrieving the matching data.

Find Mode – Searches List of Values

·         Set search parameters in the Find window.

·         A List of Values is available for many fields in Find mode.

Wild Card – Two Wild Cards

·         Use a percent symbol (%) at the beginning, end, or beginning and end of a word. The % character represents a number of character.

·         Use an underscore (_) at the beginning, end, or beginning and end of a word. The underscore represents a single character.

Field Colors

Field Color	Description
White	Allow data entry
White with green text	Indicate drill-down capability
Yellow (*)	Require Data entry
Blue with green text	Indicate drill-down capability
Blue with black text	Are display only
Blue	Indicate fields to use in Query Enter mode