•  TIBCO Data Virtualization®
  • Web UI - User Guide
  •  Preface
    • Product-Specific Documentation
    • How to Access TIBCO Documentation
    • How to Contact TIBCO Support
    • How to Join TIBCO Community
  •  Introduction
    • System Requirements
    •  How to Access TDV Web UI
      • Accessing from TDV Studio
    •  Logging in to TDV Web UI
      • User Management
      • The Login Screen
    • Overview of the Data Catalog
    • Overview of the Flow Editor
    • Navigation
    • Signing out of TDV Web UI
    • Accessing Online Help
  •  Data Catalog
    • Resource Tree
    • Search/Filter Resource
    • Resource Details
    • Creating a New Flow
  •  Flow Editor
    • Creating a Flow
    •  The Operations Palette
      • Adding a Dataset
      • Adding Columns
      • Adding Filter
      • JOIN Operation
      • UNION Operation
      • EXCEPT Operation
      • INTERSECT Operation
    • Expression Editor
    •  Publishing a Flow
      • Editing a Published Flow
  •  TDV Support for SQL Functions
    • About SQL Functions in TDV
    •  Analytical Functions
      • Window Clause
      • CONDITIONAL_CHANGE_EVENT
      • CONDITIONAL_TRUE_EVENT
      • CUME_DIST
      • DENSE_RANK
      • EXPONENTIAL_MOVING_AVERAGE
      • EXPONENTIAL_WEIGHTED_AVERAGE
      • FIRST_VALUE
      • FIRST_VALUE_IGNORE_NULLS
      • LAG
      • LAG_IGNORE_NULLS
      • LAST_VALUE
      • LAST_VALUE_IGNORE_NULLS
      • LEAD
      • LEAD_IGNORE_NULLS
      • NTH_VALUE
      • NTH_VALUE_FROM_LAST
      • NTH_VALUE_FROM_LAST_IGNORE_NULLS
      • NTH_VALUE_IGNORE_NULLS
      • NTILE
      • PERCENT_RANK
      • RANK
      • RATIO_TO_REPORT
      • ROW_NUMBER
      • TIMESERIES
    •  Aggregate Functions
      • ANY_VALUE
      • APPROX_COUNT_DISTINCT
      • APPROX_QUANTILES
      • ARRAY_AGG
      • AVG
      • BIT_AND
      • BIT_OR
      • BIT_XOR
      • CORR
      • CORR_SPEARMAN
      • COUNT
      • COVAR_POP
      • COVAR_SAMP
      • DISTINCT in Aggregate Functions
      • FIRST
      • GROUP_CONCAT
      • GROUP_CONCAT_UNQUOTED
      • LAST
      • JSON_OBJECTAGG
      • JSON_ARRAYAGG
      • LISTAGG
      • MAX
      • MEDIAN
      • MIN
      • NEST
      • NTH
      • PERCENTILE
      • PERCENTILE_APPROX
      • PERCENTILE_CONT
      • PERCENTILE_DISC
      • QUANTILES
      • REGR_AVGX
      • REGR_AVGY
      • REGR_COUNT
      • REGR_INTERCEPT
      • REGR_R2
      • REGR_ SLOPE
      • REGR_SXX
      • REGR_SXY
      • REGR_SYY
      • STDDEV
      • STDDEV_POP
      • STDDEV_SAMP
      • SUM
      • SUM_FLOAT
      • VAR_POP
      • VAR_SAMP
      • VARIANCE
      • XMLAGG
    •  Array SQL Script Functions
      • ARRAY_APPEND
      • ARRAY_AVG
      • ARRAY_CONCAT
      • ARRAY_CONTAINS
      • ARRAY_COUNT
      • ARRAY_DISTINCT
      • ARRAY_IFNULL
      • ARRAY_LENGTH
      • ARRAY_MAX
      • ARRAY_MIN
      • ARRAY_POSITION
      • ARRAY_PREPEND
      • ARRAY_PUT
      • ARRAY_REMOVE
      • ARRAY_REPLACE
      • ARRAY_REVERSE
      • ARRAY_SORT
      • ARRAY_SUM
      • TOARRAY
      • TOATOM
      • TOBOOLEAN
      • TONUMBERCB
      • TOOBJECT
      • TOSTRING
    •  Binary Functions
      • AND Functions
      • NOT Functions
      • OR Functions
      • SHL Functions
      • SHR Functions
      • XOR Functions
      • BYTE_SUBSTR
    •  Character Functions
      • ASCII
      • BASE64
      • BITCOUNT
      • BIT_LENGTH
      • BITSTRING_TO_BINARY
      • BTRIM
      • CHAR_LENGTH
      • CHARACTER_LENGTH
      • CHARINDEX
      • CHR
      • CONCAT
      • CONTAINS
      • DLE_DST
      • ENDSWITH
      • FIND
      • FIND_IN_SET
      • GET_JSON_OBJECT
      • GREATEST
      • HEX_TO_BINARY
      • INDEXOF
      • INET_ATON
      • INET_NTOA
      • INITCAP
      • INSERT
      • INSTR
      • ISOF
      • ISUTF8
      • LCASE
      • LEAST
      • LEFT
      • LENGTH
      • LE_DST
      • LOCATE
      • LOWER
      • LPAD
      • LSHIFT
      • LTRIM
      • MD5
      • OCTET_LENGTH
      • OVERLAYB
      • PARSE_URL
      • PARTIAL_STRING_MASK
      • POSITION
      • QUOTE_IDENT
      • QUOTE_LITERAL
      • REGEXP_CONTAINS
      • REGEXP_COUNT
      • REGEXP_EXTRACT
      • REGEXP_INSTR
      • REGEXP_REPLACE
      • REGEXP_SUBSTR
      • REGEXP_LIKE
      • REGEXP_POSITION
      • REPEAT
      • REVERSE
      • RIGHT
      • REPLACE
      • REGEXP
      • RLIKE
      • RPAD
      • RSHIFT
      • RTRIM
      • SPACE
      • SPLIT
      • SPLIT_PART
      • STARTSWITH
      • STATEMENT_TIMESTAMP
      • STRPOS
      • SUBSTR
      • SUBSTRING
      • SUBSTRINGOF
      • TRANSLATE
      • TRIM
      • TRIMBOTH
      • TRIMLEADING
      • TRIMTRAILING
      • TYPE
      • UCASE
      • UNICHR
      • UNICODE
      • UPPER
      • V6_ATON
      • V6_NTOA
      • V6_SUBNETA
      • V6_SUBNETN
      • V6_TYPE
    •  Conditional Functions
      • COALESCE
      • COMMON
      • DECODE
      • ES_MATCH
      • FILTER
      • IFINF
      • IFMISSING
      • IFMISSINGORNULL
      • IFNAN
      • IFNANORINF
      • IFNULL
      • IFNULLCB
      • ISARRAY
      • ISATOM
      • ISBOOLEAN
      • ISNUMBER
      • ISOBJECT
      • ISNULL
      • ISNUMERIC
      • ISSTRING
      • MATCH_PHRASE
      • MATCH_PHRASE_PREFIX
      • MISSINGIF
      • NANIF
      • NEGINFIF
      • NULLIF
      • NVL
      • NVL2
      • POSINFIF
      • TERM
      • TEST
    •  Convert Functions
      • CAST
      • FORMAT_DATE
      • PARSE_DATE
      • PARSE_TIME
      • PARSE_TIMESTAMP
      • TIMESTAMP
      • TO_BITSTRING
      • TO_CHAR
      • TO_DATE
      • TO_HEX
      • TO_NUMBER
      • TO_TIMESTAMP
      • TO_TIMESTAMP_TZ
      • TRUNC (for date/time)
      • TRUNC (for numbers)
      • TRUNCATE
    •  Cryptographic Functions
      • HASHMD2
      • HASHMD4
      • HASHMD5
      • HASHSHA
      • HASHSHA1
    •  Date Functions
      • ADD_MONTHS
      • AGE
      • AT TIME ZONE
      • CALENDAR_MONTH
      • CALENDAR_QUARTER
      • CALENDAR_YEAR
      • CLOCK_MILLIS
      • CLOCK_STR
      • CLOCK_TIMESTAMP
      • CURRENT_DATE
      • CURRENT_TIME
      • CURRENT_TIMESTAMP
      • DATE
      • DATE_ADD
      • DATE_ADD_MILLIS
      • DATE_ADD_STR
      • DATE_DIFF_MILLIS
      • DATE_DIFF_STR
      • DATE_PART
      • DATENAME
      • DATEPART
      • DATE_PART_MILLIS
      • DATE_PART_STR
      • DATE_SUB
      • DATE_TRUNC
      • DATETRUNC
      • DATE_TRUNC_MILLIS
      • DATE_TRUNC_STR
      • DAY_IN_MONTH
      • DAY_IN_WEEK
      • DAY_IN_YEAR
      • DAYNAME
      • DAYOFMONTH
      • DAYOFWEEK_ISO
      • DAYOFWEEK
      • DAYOFYEAR
      • DAY_ONLY
      • DATEDIFF
      • DAY, MONTH, and YEAR
      • DAYS
      • DAYS_BETWEEN
      • DBTIMEZONE
      • EXTRACT
      • EXTRACTDAY
      • EXTRACTDOW
      • EXTRACTDOY
      • EXTRACTEPOCH
      • EXTRACTHOUR
      • EXTRACTMICROSECOND
      • EXTRACTMILLISECOND
      • EXTRACTMINUTE
      • EXTRACTMONTH
      • EXTRACTQUARTER
      • EXTRACTSECOND
      • EXTRACTWEEK
      • EXTRACTYEAR
      • FISCAL_MONTH
      • FISCAL_QUARTER
      • FISCAL_YEAR
      • FRACTIONALSECONDS
      • FROM_UNIXTIME
      • GETUTCDATE
      • HOUR
      • HOUR_IN_DAY
      • ISFINITE
      • ISUTF8
      • JULIAN_DAY
      • LAST_DAY
      • LOCALTIME
      • LOCALTIMESTAMP
      • MICROSECOND
      • MIDNIGHT_SECONDS
      • MILLIS
      • MILLIS_TO_STR
      • MILLIS_TO_UTC
      • MAXDATETIME
      • MINDATETIME
      • MINUTE
      • MONTHNAME
      • MONTHS_BETWEEN
      • NEW_TIME
      • NEXT_DAY
      • NOW
      • NOW_MILLIS
      • NOW_STR
      • NUMTODSINTERVAL
      • NUMTOYMINTERVAL
      • QUARTER
      • ROUND
      • SECOND
      • STR_TO_MILLIS
      • STR_TO_UTC
      • STR_TO_ZONE_NAME
      • SYSDATE
      • TIME
      • TIMESTAMP_ROUND
      • TIME_SLICE
      • TIMEOFDAY
      • TIMESTAMPADD
      • TIMESTAMPDIFF
      • TIMESTAMP_TRUNC
      • TRANSACTION_TIMESTAMP
      • TOTALOFFSETMINUTES
      • TOTALSECONDS
      • TZ_OFFSET
      • TZCONVERTOR
      • UNIX_TIMESTAMP
      • UTC_TO_TIMESTAMP
      • WEEK
      • WEEK_ISO
      • WEEK_IN_MONTH
      • WEEK_IN_YEAR
      • YEAR_ISO
    •  JSON Functions
      • DECODE_JSON
      • ENCODE_JSON
      • ENCODED_SIZE
      • JSON_TABLE
      • JSON_EXTRACT
      • JSON_EXTRACT_SCALAR
      • JSON_COUNT
      • JSON_SUM
      • JSON_MIN
      • JSON_MAX
      • JSON_AVG
      • JSON_PATH
      • JSON_OBJECT
      • JSON_ARRAY
    •  Numeric Functions
      • ABS
      • ACOS
      • ASIN
      • ATAN
      • ATAN2
      • CBRT
      • CEILING
      • COS
      • COSH
      • COT
      • DECFLOAT
      • DEGREES
      • E
      • EXP
      • FLOOR
      • GEO.DISTANCE
      • GEO.INTERSECTS
      • GEO.LENGTH
      • LN
      • LOG
      • LOG10
      • MOD
      • NEGATIVE
      • NORMALIZE_DECFLOAT
      • PI
      • POW
      • POWER
      • Quantize
      • RADIANS
      • RAND
      • RANDOM
      • ROUND (for date/time)
      • ROUND (for numbers)
      • ROWNUM
      • SIGN
      • SIN
      • SINH
      • SQRT
      • TAN
      • TANH
      • TOTALORDER
    •  Operator Functions
      • Add-Operator
      • Concatenate-Operator
      • Divide-Operator
      • Exponentiate-Operator
      • Factorial-Operator
      • FACTORIAL
      • Module-Operator
      • Multiply-Operator
      • Negate-Operator
      • Subtract-Operator
    •  Phonetic Functions
      • DBL_MP
      • NYSIIS
      • PRI_MP
      • SCORE_MP
      • SEC_MP
      • SOUNDEX
      • DIFFERENCE
    • Utility Function
    •  XML Functions
      • Identifier Escaping
      • Text Escaping
      • XMLATTRIBUTES
      • XMLCOMMENT
      • XMLCONCAT
      • XMLDOCUMENT
      • XMLELEMENT
      • XML_EXTRACT
      • XMLFOREST
      • XMLNAMESPACES
      • XMLPI
      • XMLQUERY
      • XMLTEXT
      • XPATH
      • XSLT

TIBCO Data Virtualization®

XSLT