XQuery functions that supported by OSB

NAMESPACES

------------------------------------------------------------------------

xml=http://www.w3.org/XML/1998/namespace

fn=http://www.w3.org/2004/07/xpath-functions

op=http://www.w3.org/2004/07/xpath-operators

err=http://www.w3.org/2004/07/xqt-errors

fn-bea=http://www.bea.com/xquery/xquery-functions

op-bea=http://www.bea.com/xquery/xquery-operators

dt-bea=http://www.bea.com/xquery/xquery-datatypes

var-bea=http://www.bea.com/xquery/xquery-variables

xf-aug02=http://www.w3.org/2002/08/xquery-function

op-aug02=http://www.w3.org/2002/08/xquery-operators

xs=http://www.w3.org/2001/XMLSchema

xsd=http://www.w3.org/2001/XMLSchema

xdt=http://www.w3.org/2004/07/xpath-datatypes

local=http://www.w3.org/2004/07/xquery-local-functions

declare default function namespace "http://www.w3.org/2004/07/xpath-functions

XQUERY FUNCTIONS

------------------------------------------------------------------------

fn:node-name($arg as node()?) as xs:QName?

fn:nilled($arg as node()?) as xs:boolean?

fn:string($arg as item()?) as xs:string

fn:data($arg as item()*) as xdt:anyAtomicType*

fn:base-uri() as xs:anyURI?

fn:base-uri($arg as node()?) as xs:anyURI?

fn:document-uri($arg as node()?) as xs:anyURI?

fn:error() as none

fn:error($error as xs:QName) as none

fn:error($error as xs:QName?, $description as xs:string) as none

fn:error($error as xs:QName?, $description as xs:string, $error-object as item()*) as none

fn-bea:inlinedXML($arg as xs:string) as node()*

fn-bea:serialize($arg as item()*) as xs:string

xs:string($arg as xdt:anyAtomicType?) as xs:string?

xs:boolean($arg as xdt:anyAtomicType?) as xs:boolean?

xs:decimal($arg as xdt:anyAtomicType?) as xs:decimal?

xs:float($arg as xdt:anyAtomicType?) as xs:float?

xs:double($arg as xdt:anyAtomicType?) as xs:double?

xs:long($arg as xdt:anyAtomicType?) as xs:long?

xs:unsignedLong($arg as xdt:anyAtomicType?) as xs:unsignedLong?

xs:int($arg as xdt:anyAtomicType?) as xs:int?

xs:unsignedInt($arg as xdt:anyAtomicType?) as xs:unsignedInt?

xs:short($arg as xdt:anyAtomicType?) as xs:short?

xs:unsignedShort($arg as xdt:anyAtomicType?) as xs:unsignedShort?

xs:byte($arg as xdt:anyAtomicType?) as xs:byte?

xs:unsignedByte($arg as xdt:anyAtomicType?) as xs:unsignedByte?

xs:integer($arg as xdt:anyAtomicType?) as xs:integer?

xs:positiveInteger($arg as xdt:anyAtomicType?) as xs:positiveInteger?

xs:nonPositiveInteger($arg as xdt:anyAtomicType?) as xs:nonPositiveInteger?

xs:negativeInteger($arg as xdt:anyAtomicType?) as xs:negativeInteger?

xs:nonNegativeInteger($arg as xdt:anyAtomicType?) as xs:nonNegativeInteger?

xs:anyURI($arg as xdt:anyAtomicType?) as xs:anyURI?

xs:QName($arg as xs:string?) as xs:QName?

xs:Name($arg as xdt:anyAtomicType?) as xs:Name?

xs:NCName($arg as xdt:anyAtomicType?) as xs:NCName?

xs:duration($arg as xdt:anyAtomicType?) as xs:duration?

xs:dateTime($arg as xdt:anyAtomicType?) as xs:dateTime?

xs:date($arg as xdt:anyAtomicType?) as xs:date?

xs:time($arg as xdt:anyAtomicType?) as xs:time?

xs:gYearMonth($arg as xdt:anyAtomicType?) as xs:gYearMonth?

xs:gYear($arg as xdt:anyAtomicType?) as xs:gYear?

xs:gMonthDay($arg as xdt:anyAtomicType?) as xs:gMonthDay?

xs:gMonth($arg as xdt:anyAtomicType?) as xs:gMonth?

xs:gDay($arg as xdt:anyAtomicType?) as xs:gDay?

xdt:yearMonthDuration($arg as xdt:anyAtomicType?) as xdt:yearMonthDuration?

xdt:dayTimeDuration($arg as xdt:anyAtomicType?) as xdt:dayTimeDuration?

xs:normalizedString($arg as xdt:anyAtomicType?) as xs:normalizedString?

xs:hexBinary($arg as xdt:anyAtomicType?) as xs:hexBinary?

xs:base64Binary($arg as xdt:anyAtomicType?) as xs:base64Binary?

xdt:untypedAtomic($arg as xdt:anyAtomicType?) as xdt:untypedAtomic?

xs:token($arg as xdt:anyAtomicType?) as xs:token?

xs:language($arg as xdt:anyAtomicType?) as xs:language?

xs:NMTOKEN($arg as xdt:anyAtomicType?) as xs:NMTOKEN?

xs:ID($arg as xdt:anyAtomicType?) as xs:ID?

xs:IDREF($arg as xdt:anyAtomicType?) as xs:IDREF?

xs:ENTITY($arg as xdt:anyAtomicType?) as xs:ENTITY?

fn:abs($arg as numeric?) as numeric?

fn:ceiling($arg as numeric?) as numeric?

fn:floor($arg as numeric?) as numeric?

fn:round($arg as numeric?) as numeric?

fn:round-half-to-even($arg as numeric?) as numeric?

fn:round-half-to-even($arg as numeric?, $precision as xs:integer) as numeric?

fn:compare($comparand1 as xs:string?, $comparand2 as xs:string?) as xs:integer?

fn:compare($comparand1 as xs:string?, $comparand2 as xs:string?, $collation as xs:string) as xs:integer?

fn:concat($arg1 as xdt:anyAtomicType?, $arg2 as xdt:anyAtomicType?, ...) as xs:string

fn:string-join($arg1 as xs:string*, $arg2 as xs:string) as xs:string

fn-bea:trim($string as xs:string) as xs:string

fn-bea:trim-left($string as xs:string) as xs:string

fn-bea:trim-right($string as xs:string) as xs:string

fn:substring($sourceString as xs:string?, $startingLoc as xs:double) as xs:string

fn:substring($sourceString as xs:string?, $startingLoc as xs:double, $length as xs:double) as xs:string

fn:string-length($arg as xs:string?) as xs:integer

fn:normalize-space($arg as xs:string?) as xs:string

fn:normalize-unicode($arg as xs:string?) as xs:string

fn:normalize-unicode($arg as xs:string?, $normalizationForm as xs:string) as xs:string

fn:upper-case($arg as xs:string?) as xs:string

fn:lower-case($arg as xs:string?) as xs:string

fn:translate($arg as xs:string?, $mapString as xs:string, $transString as xs:string) as xs:string

fn:escape-uri($uri-part as xs:string?, $escape-reserved as xs:boolean) as xs:string

fn-bea:format-number($number as xs:double, $pattern as xs:string) as xs:string

fn:contains($arg1 as xs:string?, $arg2 as xs:string?) as xs:boolean

fn:contains($arg1 as xs:string?, $arg2 as xs:string?, $collation as xs:string) as xs:boolean

fn:starts-with($arg1 as xs:string?, $arg2 as xs:string?) as xs:boolean

fn:starts-with($arg1 as xs:string?, $arg2 as xs:string?, $collation as xs:string) as xs:boolean

fn:ends-with($arg1 as xs:string?, $arg2 as xs:string?) as xs:boolean

fn:ends-with($arg1 as xs:string?, $arg2 as xs:string?, $collation as xs:string) as xs:boolean

fn:substring-before($arg1 as xs:string?, $arg2 as xs:string?) as xs:string

fn:substring-before($arg1 as xs:string?, $arg2 as xs:string?, $collation as xs:string) as xs:string

fn:substring-after($arg1 as xs:string?, $arg2 as xs:string?) as xs:string

fn:substring-after($arg1 as xs:string?, $arg2 as xs:string?, $collation as xs:string) as xs:string

fn:matches($input as xs:string?, $pattern as xs:string) as xs:boolean

fn:matches($input as xs:string?, $pattern as xs:string, $flags as xs:string) as xs:boolean

fn:replace($input as xs:string?, $pattern as xs:string, $replacement as xs:string) as xs:string

fn:replace($input as xs:string?, $pattern as xs:string, $replacement as xs:string, $flags as xs:string) as xs:string

fn:tokenize($input as xs:string?, $pattern as xs:string) as xs:string?

fn:tokenize($input as xs:string?, $pattern as xs:string, $flags as xs:string) as xs:string?

fn:codepoints-to-string($arg as xs:integer*) as xs:string

fn:string-to-codepoints($arg as xs:string?) as xs:integer*

fn:resolve-uri($relative as xs:string?) as xs:anyURI?

fn:resolve-uri($relative as xs:string?, $base as xs:string) as xs:anyURI?

fn:true() as xs:boolean

fn:false() as xs:boolean

fn:not($arg as item()*) as xs:boolean

fn:years-from-duration($arg as xdt:yearMonthDuration?) as xs:integer?

fn:months-from-duration($arg as xdt:yearMonthDuration?) as xs:integer?

fn:days-from-duration($arg as xdt:dayTimeDuration?) as xs:integer?

fn:hours-from-duration($arg as xdt:dayTimeDuration?) as xs:integer?

fn:minutes-from-duration($arg as xdt:dayTimeDuration?) as xs:integer?

fn:seconds-from-duration($arg as xdt:dayTimeDuration?) as xs:decimal?

fn:year-from-dateTime($arg as xs:dateTime?) as xs:integer?

fn:month-from-dateTime($arg as xs:dateTime?) as xs:integer?

fn:day-from-dateTime($arg as xs:dateTime?) as xs:integer?

fn:hours-from-dateTime($arg as xs:dateTime?) as xs:integer?

fn:minutes-from-dateTime($arg as xs:dateTime?) as xs:integer?

fn:seconds-from-dateTime($arg as xs:dateTime?) as xs:decimal?

fn:year-from-date($arg as xs:date?) as xs:integer?

fn:month-from-date($arg as xs:date?) as xs:integer?

fn:day-from-date($arg as xs:date?) as xs:integer?

fn:hours-from-time($arg as xs:time?) as xs:integer?

fn:minutes-from-time($arg as xs:time?) as xs:integer?

fn:seconds-from-time($arg as xs:time?) as xs:decimal?

fn:timezone-from-time($arg as xs:time?) as xdt:dayTimeDuration?

fn:timezone-from-date($arg as xs:date?) as xdt:dayTimeDuration?

fn:timezone-from-dateTime($arg as xs:dateTime?) as xdt:dayTimeDuration?

fn:adjust-dateTime-to-timezone($arg as xs:dateTime?) as xs:dateTime?

fn:adjust-dateTime-to-timezone($arg as xs:dateTime?, $timezone as xdt:dayTimeDuration?) as xs:dateTime?

fn:adjust-date-to-timezone($arg as xs:date?) as xs:date?

fn:adjust-date-to-timezone($arg as xs:date?, $timezone as xdt:dayTimeDuration?) as xs:date?

fn:adjust-time-to-timezone($arg as xs:time?) as xs:time?

fn:adjust-time-to-timezone($arg as xs:time?, $timezone as xdt:dayTimeDuration?) as xs:time?

fn-bea:add-timezone-to-dateTime($arg as xs:dateTime) as xs:dateTime

fn-bea:add-timezone-to-dateTime($arg as xs:dateTime, $duration as xs:dayTimeDuration) as xs:dateTime

fn-bea:remove-timezone-from-dateTime($arg as xs:dateTime) as xs:dateTime

fn-bea:remove-timezone-from-dateTime($arg as xs:dateTime, $duration as xs:dayTimeDuration) as xs:dateTime

fn-bea:add-timezone-to-date($arg as xs:date) as xs:date

fn-bea:add-timezone-to-date($arg as xs:date, $duration as xs:dayTimeDuration) as xs:date

fn-bea:add-timezone-to-time($arg as xs:time) as xs:time

fn-bea:add-timezone-to-time($arg as xs:time, $duration as xs:dayTimeDuration) as xs:time

fn-bea:remove-timezone-from-time($arg as xs:time) as xs:time

fn-bea:remove-timezone-from-time($arg as xs:time, $duration as xs:dayTimeDuration) as xs:time

fn:resolve-QName($qname as xs:string?, $element as element()) as xs:QName?

fn:expanded-QName($paramURI as xs:string?, $paramQName as xs:string) as xs:QName

fn:local-name-from-QName($arg as xs:QName?) as xs:NCNAME?

fn:namespace-uri-from-QName($arg as xs:QName?) as xs:anyURI?

fn:namespace-uri-for-prefix($prefix as xs:string, $element as element()) as xs:anyURI?

fn:in-scope-prefixes($element as element()) as xs:string*

fn:name($arg as node()?) as xs:string

fn:local-name($arg as node()?) as xs:string

fn:namespace-uri($arg as node()?) as xs:anyURI

fn:number($arg as xdt:anyAtomicType?) as xs:double

fn:lang($testlang as xs:string?, $node as node()) as xs:boolean

fn:root($arg as node()?) as node()?

fn:boolean($arg as item()*) as xs:boolean

op:concatenate($seq1 as item()*, $seq2 as item()*) as item()*

fn:index-of($seqParam as xdt:anyAtomicType*, $srchParam as xdt:anyAtomicType) as xs:integer*

fn:index-of($seqParam as xdt:anyAtomicType*, $srchParam as xdt:anyAtomicType, $collation as xs:string) as xs:integer*

fn:empty($arg as item()*) as xs:boolean

fn:exists($arg as item()*) as xs:boolean

fn:distinct-values($arg as xdt:anyAtomicType*) as xdt:anyAtomicType*

fn:distinct-values($arg as xdt:anyAtomicType*, $collation as xs:string) as xdt:anyAtomicType*

fn:insert-before($target as item()*, $position as xs:integer, $inserts as item()*) as item()*

fn:remove($target as item()*, $position as xs:integer) as item()*

fn:reverse($arg as item()*) as item()*

fn:subsequence($sourceSeq as item()*, $startingLoc as xs:double) as item()*

fn:subsequence($sourceSeq as item()*, $startingLoc as xs:double, $length as xs:double) as item()*

fn:zero-or-one($arg as item()*) as item()?

fn:one-or-more($arg as item()*) as item()+

fn:exactly-one($arg as item()*) as item()

fn:deep-equal($parameter1 as item()*, $parameter2 as item()*) as xs:boolean

fn:deep-equal($parameter1 as item()*, $parameter2 as item()*, $collation as string) as xs:boolean

fn:count($arg as item()*) as xs:integer

fn:avg($arg as xdt:anyAtomicType*) as xdt:anyAtomicType?

fn:max($arg as xdt:anyAtomicType*) as xdt:anyAtomicType?

fn:max($arg as xdt:anyAtomicType*, $collation as string) as xdt:anyAtomicType?

fn:min($arg as xdt:anyAtomicType*) as xdt:anyAtomicType?

fn:min($arg as xdt:anyAtomicType*, $collation as string) as xdt:anyAtomicType?

fn:sum($arg as xdt:anyAtomicType*) as xdt:anyAtomicType

fn:sum($arg as xdt:anyAtomicType*, $zero as xdt:anyAtomicType?) as xdt:anyAtomicType?

fn-bea:integer-sequence($seq as node()*) as integer*

fn:doc($uri as xs:string?) as document-node()?

fn:position() as xs:integer

fn:last() as xs:integer

fn:current-dateTime() as xs:dateTime

fn:current-date() as xs:date

fn:current-time() as xs:time

fn:implicit-timezone() as xdt:dayTimeDuration

fn:default-collation() as xs:string

fn-bea:execute-sql($datasource as xs:string, $rowElemName as xdt:anyAtomicType, $sql as xs:string, $params...) as element()*

Source: http://www.tomecode.com/download/OSB_11g_XQueryFunction_list.txt