DESCRIPTION L eft TRIM trims all the occurrences of any one of a set of characters off of the left side of a string.
EXAMPLE
LTRIM('NANCY','AN')
produces this:
CY
MAKE_REF
SEE ALSO Chapter 41
FORMAT
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.
MAX
SEE ALSO AGGREGATE FUNCTIONS, COMPUTE, MIN, Chapter 9
FORMAT
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 ...
Get Oracle Database 11g The Complete Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
