The following programs demonstrate the use of the MATCHING
conditional expression and the SORTED clause. These programs
create a record stream containing all the records in the
EMPLOYEES relation in which the field LAST_NAME begins with the
letter "R". Then the programs sort the record stream in ascending
numerical order of the employee IDS. These programs print, in
numerical order, the employee ID, followed by the last name and
first name for all the records in the record stream.
Additional Information:
explode
extract