O'Reilly logo

Oracle Database 11g The Complete Reference by Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required