Global Functions

Table 4 lists restrictions on the global functions associated with RWDBExpr.

Table 236. Restrictions on the use of global functions

Function

Restrictions

rwdbAvg(const RWDBExpr&)

None. Corresponds to: AVG(expr)

rwdbCast(const RWDBExpr&,

const RWDBValue&)

See rwdbCast().

rwdbCast(const RWDBExpr&,

const RWDBValue&,

const RWDBExpr&)

See rwdbCast().

rwdbCast(const RWBDExpr&,

const RWDBValue&,

const RWDBExpr&,

const RWDBExpr&)

See rwdbCast().

rwdbCharLength(const RWDBExpr&)

None. Corresponds to: LENGTH(expr)

rwdbCount()

None. Corresponds to: COUNT(*)

rwdbCount(const RWDBExpr&)

None. Corresponds to: COUNT(expr)

rwdbCountDistinct(const RWDBExpr&)

None. Corresponds to: COUNT(DISTINCT expr)

rwdbCurrentUser()

None. Corresponds to: SYS_CONTEXT('USERENV','CURRENT_USER')

rwdbExists(const RWDBSelectorBase&)

None. Corresponds to: EXISTS(sel)

rwdbLower(const RWDBExpr&)

None. Corresponds to: LOWER(expr)

rwdbMax(const RWDBExpr&)

None. Corresponds to: MAX(expr)

rwdbMin(const RWDBExpr&)

None. Corresponds to: MIN(expr)

rwdbName(const RWCString&,

const RWDBExpr&)

None. Corresponds to: expr string

rwdbPosition(const RWDBExpr&,

const RWDBExpr&)

None. Corresponds to: INSTR(expr1, expr0)

rwdbSessionUser()

None. Corresponds to: SYS_CONTEXT('USERENV','SESSION_USER')

rwdbSubString(const RWDBExpr&,

const RWDBExpr&)

None. Corresponds to: SUBSTR(expr0, expr1)

rwdbSubString(const RWDBExpr&,

const RWDBExpr&,

const RWDBExpr&)

None. Corresponds to: SUBSTR(expr0, expr1, expr2)

rwdbSum(const RWDBExpr&)

None. Corresponds to: SUM(expr)

rwdbSystemDateTime()

None. Corresponds to: SYSDATE

rwdbSystemUser()

None. Corresponds to: SYS_CONTEXT('USERENV','OS_USER')

rwdbTrimLeading(const RWDBExpr&,

const RWDBExpr&)

None. Corresponds to: LTRIM(expr1, expr0)

rwdbTrimTrailing(const RWDBExpr&,

const RWDBExpr&)

None. Corresponds to: RTRIM(expr1, expr0)

rwdbTrimBoth(const RWDBExpr&,

const RWDBExpr&)

None. Corresponds to: LTRIM(RTRIM(expr1, expr0), expr0)

rwdbUpper(const RWDBExpr&)

None. Corresponds to: UPPER(expr)