REFERENCE HANDOUT Information Technology Services UA Help Desk and Training [email protected]

SQL Reference Handout

Table of Contents COMPARISON OPERATORS ................................................................................................................. 3 NUMERIC FUNCTIONS .......................................................................................................................... 4 TEXT FUNCTIONS ................................................................................................................................... 4 CONVERSION FUNCTIONS ................................................................................................................... 4 AGGREGATE FUNCTIONS .................................................................................................................... 5 SQL*PLS ..................................................................................................................................................... 5 APPENDIX.................................................................................................................................................. 6

OIT Support Center and Training—Providing consultation, solutions and training for University computing needs.

2

SQL Reference Handout

Comparison Operators Operator

Meaning

Example

=

equal, exact match

TERM_CODE = '199703' AGE = 40 BIRTH_DATE = ‘01-JAN-98’

>

greater than

TERM_CODE > '199703’ AGE > 40 BIRTH_DATE > ‘01-JAN-98’