Contents
- Title and Copyright Information
- Preface
- 1 Introduction
- 2 Installation
- 3 Description
- 4 Getting Started
- 5 Using TCC
- 6 Net Change
- 7 Templates
- Best Practice Templates
- Candidate Standard Net Change
- Candidate Standard Export
- Department Standard Net Change
- JobField Standard Net Change
- JobTemplate Standard Net Change
- Location Standard Net Change
- LUDS Standard Net Change
- Organization Standard Net Change
- Position Standard Net Change
- Requisition Standard Merge
- User Standard Net Change
- 8 Advanced Queries
- Introduction
- Inserting Complex Queries
- Examples
- Between
- Case (Switch by criterion)
- Case (Switch by value)
- Concatenate
- Connect By
- Count
- dbms_lob.getlength
- dbms_lob.instr
- dbms_lob.substr
- Decode
- Distinct
- Dual
- Exists / Not Exists
- Greater Than
- Group By
- Having
- In
- Inner Join
- Intersect
- Less Than
- Like
- Minus
- NVL
- Or
- Order By
- Outer Join
- Rownum
- SubString
- ToChar
- Trim
- Truncate
- Union
- Union All
- Other Custom Functions
- Custom Function Example
- Oracle Reserved Words
- 9 Security
- 10 Appendix