Best Practices, Knowledge Areas, OC RDC, Oracle

Oracle Clinical (OC) Cheat Sheet

2 Comments

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