Oracle Clinical (OC) Cheat Sheet

OC Shortcuts

Code	Description
Space Bar	Check or uncheck Checkbox
CRTL+Q	Back up to last screen and/or Exit
F3	Copy data from row above
F6	Insert new record below
F7	Enter into Query mode
F8	Execute Query
F9	List of Values (LOV) for entry
F10	Save
ROUND	ROUND(number,precision) – Rounds number to the decimal value determined in the precision parameter e.g. ROUND(BMI,1)
TRUNC	TRUNC(number) – Removes decimal places from number e.g. TRUNC(WEIGHT)
NVL	NVL(string,’value if null’) – Returns specified value if string is null e.g. NVL(VITALS.VISITDT,’01’)
DECODE	DECODE(expression,value1, return1, value2, return2,,,,,, default) – Functions as an inline if statement. If the expression results in value 1, then report return1, and so on. If no values are found function returns the default.e.g. DECODE(VISIT_NO,10,20,30,40,50,88,99)
UPPER/LOWER	UPPER(string) / LOWER(string) – Sets string to all uppercase or lowercase e.g. UPPER(AETERM) LOWER(AETERM)
LENGTH	LENGTH(string) – Returns an integer value of the length of the value of the string e.g. LENGTH(ENROLL.RANDOMNO) < 6

Source: OC User Manual