SourcePro DB : DB Access Module for Oracle OCIUser’s Guide : Technical Information : Expressions : Global Functions
Global Functions
Table 4 lists restrictions on the global functions associated with RWDBExpr.
Table 4 – Restrictions on the use of global functions 
Function
Restrictions
rwdbAvg(const RWDBExpr&)
None. Corresponds to: AVG(expr)
rwdbCast(const RWDBExpr&,
const RWDBValue&)
rwdbCast(const RWDBExpr&,
const RWDBValue&,
const RWDBExpr&)
rwdbCast(const RWBDExpr&,
const RWDBValue&,
const RWDBExpr&,
const RWDBExpr&)
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)
Additional product documentation
About SourcePro
SourcePro Resources
Technical Support
Visit us at: https://www.perforce.com/support/request-support

Copyright © 2023 Perforce Software, Inc. All rights reserved.