DESCRIPTION L eft TRIM trims all the occurrences of any one of a set of characters off of the left side of a string.
SEE ALSO Chapter 41
MAKE_REF (table | view , key [, key])
DESCRIPTION MAKE_REF constructs a REF (reference) from the foreign key of a table that references the base table of an object view. MAKE_REF allows you to construct references superimposed on existing foreign key relationships. See Chapter 41 for examples.
SEE ALSO AGGREGATE FUNCTIONS, COMPUTE, MIN, Chapter 9
MAX([DISTINCT | ALL] value) [OVER analytic_clause]
DESCRIPTION MAX is the maximum of all values for a group of rows. MAX ignores NULL values. The DISTINCT option is not meaningful, since the maximum ...