Index

A B C D E F G H I L M N O P R S T U V W X

A

ABS function, 2.6.1

accessing

transformation libraries, 1.2.2

ACOS function, 2.6.2

ADD_MONTHS function, 2.5.1

administrative transformations, 2.1

ASCII function, 2.2.1

ASCIISTR function, 2.4.1

ASIN function, 2.6.3

ATAN function, 2.6.4

ATAN2 function, 2.6.5

B

BITAND function, 2.6.6

C

CEIL function, 2.6.7

character transformations, 2.2

CHR function, 2.2.2

coding conventions, Preface

COMPOSE function, 2.4.2

CONCAT function, 2.2.3

control center transformations, 2.3

conventions

coding, Preface

example, Preface

conversion transformations, 2.4

CONVERT function, 2.4.3

COS function, 2.6.8

COSH function, 2.6.9

creating

PL/SQL types, 1.3.2

CURRENT_DATE function, 2.5.2

custom transformations

about, 1.1.1.2

defining, 1.3

editing, 1.4

D

date transformations, 2.5, 2.5

DBTIMEZONE function, 2.5.3

DEPTH function, 2.8.1

DUMP function, 2.8.2

E

editing

PL/SQL types, 1.4.2

transformation properties, 1.4

EMPTY_BLOB, EMPTY_CLOB function, 2.8.3

example conventions, Preface

EXISTSNODE function, 2.11.1

EXP function, 2.6.10

EXTRACT function, 2.11.2

EXTRACTVALUE function, 2.11.3

F

filters, with a transform, 1.5

FLOOR function, 2.6.11, 2.6.11

FROM_TZ function, 2.5.4

functions

as transformations, 1.1.1.2

defining, 1.3

editing, 1.4

G

global shared library, 1.2.1

H

HEXTORAW function, 2.4.4

I

importing

PL/SQL functions, 1.5

INITCAP function, 2.2.4

INSTR function, 2.2.5

INSTR2 function, 2.2.5, 2.2.5

INSTR4 function, 2.2.5, 2.2.5

INSTRB function, 2.2.5, 2.2.5

INSTRC function, 2.2.5, 2.2.5

L

LAST_DAY function, 2.5.5

LENGTH function, 2.2.6

LENGTH2 function, 2.2.6, 2.2.6

LENGTH4 function, 2.2.6, 2.2.6

LENGTHB function, 2.2.6, 2.2.6

LENGTHC function, 2.2.6, 2.2.6

LN function, 2.6.12

LOG function, 2.6.13

LOWER function, 2.2.7

LPAD function, 2.2.8

LTRIM function, 2.2.9

M

MOD function, 2.6.14

MONTHS_BETWEEN function, 2.5.6

N

NANVL function, 2.6.15

NEW_TIME function, 2.5.7

NEXT_DAY function, 2.5.8

NLS_CHARSET_DECL_LEN function, 2.8.4

NLS_CHARSET_ID function, 2.8.5

NLS_CHARSET_NAME function, 2.8.6

NLS_INITCAP function, 2.2.11

NLS_LOWER function, 2.2.12

NLS_UPPER function, 2.2.13

NLSSORT function, 2.2.10

NULLIF function, 2.8.7

number transformations, 2.6, 2.6

NUMTODSINTERVAL function, 2.4.5

NUMTOYMINTERVAL function, 2.4.6

NVL2 function, 2.8.9

O

OLAP transformations, 2.7

ORA_HASH function, 2.8.10

Oracle library, 1.2.1

other (non-SQL) transformations, 2.8

P

packages

as transformations, 1.1.1.2

defining, 1.3

editing, 1.4

PATH function, 2.8.11

PL/SQL types

creating, 1.3.2

editing, 1.4.2

POWER function, 2.6.16

predefined transformations, 1.1.1.1

procedures

as transformations, 1.1.1.2

defining, 1.3

editing, 1.4

projects

importing PL/SQL into, 1.5

R

RAWTOHEX function, 2.4.7

RAWTONHEX function, 2.4.8

REGEXP_INSTR function, 2.2.15

REGEXP_REPLACE function, 2.2.16

REGEXP_SUBSTR function, 2.2.17

REMAINDER function, 2.6.17

REPLACE function, 2.2.14

REPLICATE, 2.10.1

ROUND function, 2.5.9, 2.6.18

RPAD function, 2.2.18

RTRIM function, 2.2.19

S

SCN_TO_TIMESTAMP function, 2.4.9

SDO_AGGR_CENTROID function, 2.9.1

SDO_AGGR_CONVEXHULL function, 2.9.2

SDO_AGGR_MBR function, 2.9.3

SDO_AGGR_UNION function, 2.9.4

SESSIONTIMEZONE function, 2.5.10

SIGN function, 2.6.19

SIN function, 2.6.20

SINH function, 2.6.21

SOUNDEX function, 2.2.20

Spatial Transformations, 2.9

SQRT function, 2.6.22

streams transformations, 2.10

SUBSTR function, 2.2.21

SUBSTR2 function, 2.2.21, 2.2.21

SUBSTR4 function, 2.2.21, 2.2.21

SUBSTRB function, 2.2.21, 2.2.21

SUBSTRC function, 2.2.21, 2.2.21

SYS_CONTEXT function, 2.8.12

SYS_EXTRACT_UTC function, 2.5.13

SYS_GUID function, 2.8.13

SYS_TYPEID function, 2.8.14

SYS_XMLAGG, 2.11.4

SYS_XMLGEN function, 2.11.5

SYSDATE function, 2.5.11

SYSTIMESTAMP function, 2.5.12

T

TAN function, 2.6.23

TANH function, 2.6.24

TIMESTAMP_TO_SCN function, 2.4.10

TO_BINARY_DOUBLE function, 2.4.11

TO_BINARY_FLOAT function, 2.4.12

TO_CHAR function, 2.4.13

TO_CLOB function, 2.4.14

TO_DATE function, 2.4.15

TO_DSINTERVAL function, 2.4.16

TO_MULTI_BYTE function, 2.4.17

TO_NCHAR function, 2.4.18

TO_NCLOB function, 2.4.19

TO_NUMBER function, 2.4.20

TO_SINGLE_BYTE function, 2.4.21, 2.4.21

TO_TIMESTAMP function, 2.4.22

TO_TIMESTAMP_TZ function, 2.4.23

TO_YMINTERVAL function, 2.4.24

transformation filter data, 1.5

transformation libraries

about, 1.2

accessing, 1.2.2, 1.2.2

global shared library, 1.2.1

Oracle library, 1.2.1

types, 1.2.1

types of, 1.2.1

transformation properties, 1.4

transformations

about, 1.1, 1.1

administrative, 2.1, 2.1

character, 2.2

control center, 2.3

conversion, 2.4

custom, 1.1.1.2

custom example, 1.5

date, 2.5, 2.5

importing, 1.5

introduction to, 1

number, 2.6, 2.6

OLAP, 2.7

other (non-SQL), 2.8

predefined, 1.1.1.1

streams, 2.10

types of, 1.1.1

XML, 2.11

TRANSLATE function, 2.2.22

TRIM function, 2.2.23

TRUNC function, 2.5.14, 2.6.25

U

UID function, 2.8.15

UNISTR function, 2.4.25

UPPER function, 2.2.24

USER function, 2.8.16

USERENV function, 2.8.17

V

VSIZE function, 2.8.18

W

WB_ABORT function, 2.1.1

WB_CAL_MONTH_NAME function, 2.5.15

WB_CAL_MONTH_OF_YEAR function, 2.5.16

WB_CAL_MONTH_SHORT_NAME function, 2.5.17

WB_CAL_QTR function, 2.5.18

WB_CAL_WEEK_OF_YEAR function, 2.5.19

WB_CAL_YEAR function, 2.5.20

WB_CAL_YEAR_NAME function, 2.5.21

WB_COMPILE_PLSQL transformation, 2.1.2

WB_DATE_FROM_JULIAN function, 2.5.22

WB_DAY_NAME function, 2.5.23

WB_DAY_OF_MONTH function, 2.5.24

WB_DAY_OF_WEEK function, 2.5.25

WB_DAY_OF_YEAR function, 2.5.26

WB_DAY_SHORT_NAME function, 2.5.27

WB_DECADE function, 2.5.28

WB_DISABLE_ALL_CONSTRAINTS, 2.1.3

WB_DISABLE_ALL_TRIGGERS, 2.1.4

WB_DISABLE_CONSTRAINT, 2.1.5

WB_DISABLE_TRIGGER, 2.1.6

WB_ENABLE_ALL_CONSTRAINTS, 2.1.7

WB_ENABLE_ALL_TRIGGERS, 2.1.8

WB_ENABLE_CONSTRAINT, 2.1.9

WB_ENABLE_TRIGGER, 2.1.10

WB_HOUR12 function, 2.5.29

WB_HOUR12MI_SS function, 2.5.30

WB_HOUR24 function, 2.5.31

WB_HOUR24MI_SS function, 2.5.32

WB_IS_DATE function, 2.5.33

WB_IS_NUMBER function, 2.6.28

WB_IS_SPACE function, 2.2.27

WB_JULIAN_FROM_DATE function, 2.5.34

WB_LOOKUP_CHAR function, 2.2.25, 2.2.26

WB_LOOKUP_NUM function, 2.6.26, 2.6.27

WB_MI_SS function, 2.5.35

WB_OLAP_AW_PRECOMPUTE, 2.7.1

WB_OLAP_LOAD_CUBE, 2.7.2

WB_OLAP_LOAD_DIMENSION, 2.7.3

WB_OLAP_LOAD_DIMENSION_GENUK, 2.7.4

WB_RT_GET_ELAPSED_TIME function, 2.3.1

WB_RT_GET_JOB_METRICS function, 2.3.2

WB_RT_GET_LAST_EXECUTION_TIME, 2.3.3

WB_RT_GET_MAP_RUN_AUDIT function, 2.3.4

WB_RT_GET_NUMBER_OF_ERRORS function, 2.3.5

WB_RT_GET_NUMBER_OF_WARNINGS function, 2.3.6

WB_RT_GET_PARENT_AUDIT_ID function, 2.3.7

WB_RT_GET_RETURN_CODE function, 2.3.8

WB_RT_GET_START_TIME function, 2.3.9

WB_TRUNCATE_TABLE, 2.1.11

WB_WEEK_OF_MONTH function, 2.5.36

WB_XML_LOAD, 2.11.6

WB_XML_LOAD_F, 2.11.7

WIDTH_BUCKET function, 2.6.29

X

XML Transformations, 2.11

XMLCONCAT function, 2.11.8

XMLSEQUENCE function, 2.11.9

XMLTRANSFORM function, 2.11.10