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
2 thoughts on “Oracle Clinical (OC) Cheat Sheet”
Comments are closed.