You are previewing Oracle Discoverer 10g Handbook.
O'Reilly logo
Oracle Discoverer 10g Handbook

Book Description

Generate detailed reports that will give your company the competitive edge

Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10g.

  • Set up, configure, and manage Oracle Business Intelligence Discoverer 10g
  • Perform ad hoc and fixed queries using the Workbook Wizard
  • Integrate sorts, calculations, percentages, and parameters using Discoverer Plus
  • Create reports with graphs, tables, titles, headers, footers, and margins
  • Use Discoverer Viewer to review, format, export, email, and print reports
  • Refine queries using interactive pivoting, drilling, and Hyper Drilling
  • Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager
  • Establish access and sharing rights, and scheduling privileges with Discoverer Administrator
  • Set up and use Portal using Discoverer Portlet Provider and Portlets
  • Implement query shortcuts, cascading parameters and advanced analytic calculations using templates

Table of Contents

  1. Cover Page
  2. Oracle Discoverer 10g Handbook
  3. Copyright Page
  4. Dedication
  5. Contents
  6. Acknowledgments
  7. Introduction
  8. Part I Getting Started with Discoverer
    1. 1 An Overview of Discoverer
      1. Business Intelligence and Your Organization
      2. Business Intelligence and Trends
      3. Recent Business Intelligence Trends and Discoverer
      4. Discoverer’s Role in Business Intelligence
      5. Oracle Introduces Discoverer
      6. Discoverer on the Web
      7. The Eight Parts of Discoverer
      8. How to Use This Book
      9. Example Database
      10. A New Direction in Reporting
      11. The Discoverer GUI
      12. The Benefits of a GUI
      13. Ad Hoc Queries vs
      14. Getting Help with Discoverer
      15. Summary
    2. 2 Users and Databases
      1. What Starts Right Stays Right
      2. The Responsibility of the End User
      3. Your Business
      4. Your Reporting Requirements
      5. Your Database
      6. The Discoverer Library Concept
      7. The Definition of a Library
      8. The Definition of a Library Manager
      9. The Report Writer Concept
      10. The Definition of a Report Writer
      11. The Benefits of Having Report Writers
      12. The Benefits of Being a Report Writer
      13. Choosing Your Report Writers
      14. Summary
    3. 3 Getting Started in Discoverer
      1. Key Personnel
      2. Discoverer Manager
      3. Library Manager
      4. Database Administrator
      5. Oracle Applications (Apps) Administrator
      6. Report Writers
      7. Gaining Access to Discoverer
      8. Key Definitions
      9. Workbooks and Worksheets
      10. Queries
      11. Reports
      12. Libraries
      13. Sticky Features
      14. Main Features of Discoverer
      15. Discoverer Login Sequence
      16. Connecting Using Discoverer Desktop
      17. Launching 10
      18. Starting a Workbook
      19. Summary
    4. 4 The Workbook Wizard: The Essential Steps
      1. The Workbook Wizard
      2. The Workbook Wizard Steps
      3. A Simple Workflow
      4. The Workbook Wizard Options
      5. Workbook Wizard Step 1: Create a New Workbook or Open an Existing Workbook
      6. Open an Existing Workbook
      7. Workbook Wizard Step 2: Selecting the Data
      8. Workbook Wizard Step 3: Arranging the Order of the Output
      9. Workbook Wizard Step 4: Setting User-Defined Conditions
      10. The Query from the Twilight Zone and How to Avoid It
      11. Viewing the Results
      12. Saving the Query
      13. Summary
    5. 5 The Workbook Wizard: The Optional Steps
      1. The Text Area in Plus
      2. The Optional Steps of the Workbook Wizard
      3. Workbook Wizard Step 5: Creating a Sort Order (Tables Only)
      4. Sorting: What Is It?
      5. Creating a New Sort
      6. Quick Sorting
      7. Refining a Sort
      8. Building a Group Sort
      9. Adding Another Sort
      10. Rearranging the Sort Order
      11. Why Not Sort in the Wizard?
      12. Workbook Wizard Step 6: Creating User-Defined Calculations
      13. Desktop Calculations Screen
      14. Plus Calculations Tab
      15. Calculations: What Are They?
      16. Creating a Calculation in Desktop
      17. Creating a Calculation in Plus
      18. Understanding Calculations
      19. Why Not Calculate in the Wizard?
      20. Discoverer Plus Workbook Wizard Remaining Steps
      21. Creating User-Defined Percentages in the Plus Workbook Wizard
      22. Percentages: What Are They?
      23. Creating a New Percentage
      24. Examples of Percentages
      25. Why Not Perform Percentages in the Wizard?
      26. Creating User-Defined Totals in the Plus Workbook Wizard
      27. Totals: What Are They?
      28. Creating a New Total
      29. Labeling Percentages and Totals
      30. Creating User-Defined Parameters in the Plus Workbook Wizard
      31. Parameters: What Are They?
      32. Differences Between Conditions and Parameters
      33. Creating a New Parameter
      34. Rearranging the Parameter Order
      35. Why Not Create Parameters in the Wizard?
      36. Editing the Sheet After the Query Has Run
      37. Summary
  9. Part II Editing the Query
    1. 6 Formatting the Output in Discoverer Desktop and Plus
      1. Giving Your Headings Meaningful Names (Desktop and Plus)
      2. How to Rename Columns in Desktop
      3. How to Rename Columns in Plus
      4. Rearranging the Order of the Output
      5. How to Rearrange Columns
      6. Formatting Data
      7. Formatting Tools
      8. Format Data Dialog Box
      9. Formatting Columns
      10. Formatting Column Headings
      11. Formatting Multiple Headings and Columns in Plus
      12. Deleting Columns from a Worksheet
      13. How to Delete a Column
      14. Resizing Columns
      15. Formatting Totals
      16. Formatting Totals Using the Format Data Dialog Box
      17. Formatting Totals from the Formatting Bar
      18. Formatting Exceptions
      19. Adding a Title to Your Query
      20. Editing the Title
      21. Suppressing a Title from Displaying
      22. Adding a Background Bitmap (Desktop Only)
      23. Setting a Background
      24. Clearing a Background
      25. Summary
    2. 7 Using Graphs to Present Data
      1. The Available Graph Styles
      2. Area (Desktop and Plus)
      3. Bar (Desktop and Plus)
      4. Combination (Plus Only)
      5. Cube (Grouped with 3-D Options in Plus)
      6. Doughnut (Grouped with Pie in Plus)
      7. Fit to Curve (Desktop Only)
      8. Hi-Low-Close (Desktop,) Stock (Plus)
      9. Horizontal Bar (Desktop and Plus)
      10. Line (Desktop and Plus)
      11. Pareto (Desktop and Plus)
      12. Pie (Desktop and Plus)
      13. Point (Desktop Only)
      14. Polar (Desktop and Plus)
      15. Scatter (Desktop), Scatter/Bubble (Plus)
      16. Surface (Grouped with 3-D in Plus)
      17. The Discoverer Desktop Graph Window
      18. The Features of the Discoverer Desktop Graph Window
      19. Creating a Graph in Desktop
      20. The Desktop Graph Wizard
      21. Graphing in Discoverer Plus
      22. Creating a Graph in the Plus Workbook Wizard
      23. Creating a Graph in Plus after a Query Has Been Generated
      24. Modifying a Graph in Plus
      25. Modifying a Graph in Desktop
      26. To Modify the Graph from the Worksheet
      27. To Modify the Graph from the Graph Window
      28. Summary
    3. 8 Turning a Discoverer Query into a Report
      1. A Workflow for Building Reports
      2. Report Workflow
      3. Formatting the Report for Printing
      4. Print Setup in Desktop
      5. Print Setup in Plus
      6. Page Setup
      7. The Sheet Tab in Desktop
      8. The Worksheet Tab in Plus
      9. The Table/Crosstab Tab in Plus
      10. Header and Footers
      11. Table and Crosstab Gridlines
      12. Table Gridlines
      13. Crosstab Gridlines
      14. Inserting Page Breaks in Tables (Sorry, No Page Breaks in Crosstabs)
      15. Exporting Your Report to Another Application
      16. Summary
    4. 9 Using Discoverer to Analyze Data
      1. What Is Analysis?
      2. Types of Analysis
      3. Statistical Analysis
      4. Classification Analysis
      5. Deviation Analysis
      6. Trend Analysis
      7. Aging Analysis
      8. Fundamentals of Analysis
      9. An Analysis Workflow
      10. Core Examples Used in This Chapter
      11. Description of the Analysis Tools Available
      12. Turning a Tool On and Off
      13. The Analysis Toolbar Buttons
      14. Totals Area
      15. Percentage Area
      16. Operators Area
      17. Conditions Area
      18. Finding Exceptions Using Formatting
      19. How to Build the Example Queries
      20. Statistical Analysis
      21. Classification Analysis
      22. Deviation Analysis
      23. Trend Analysis
      24. Aging Analysis
      25. Overcoming the Manager Who Is Wary of Your Analysis
      26. Summary
    5. 10 Business Intelligence Discoverer Viewer 10g Release 2 (10.1.2)
      1. Why Use Viewer?
      2. The Benefits of Viewer
      3. New or Improved Features
      4. The Connect Page
      5. The Worksheet List
      6. The Main Viewer Page
      7. The Table or Crosstab Display Area
      8. Tools
      9. Sort
      10. Rows and Columns
      11. Hyper-Drilling
      12. Graphs
      13. Drilling in Graphs
      14. Setting Up User Preferences in Viewer
      15. Query Governor
      16. Measure Units
      17. Axis Labels
      18. Summary Data
      19. Summary
  10. Part III Advanced Discoverer Techniques
    1. 11 Refining Items, Drilling, and Hyper-Drilling
      1. Refining Query Items
      2. Adding or Removing Items
      3. Common Problems Associated with Adding or Removing Items
      4. Pivoting and Drilling
      5. Pivoting Data
      6. Duplicating Tables and Crosstabs as New Worksheets
      7. Renaming Worksheets
      8. Drilling Into and Out of Data
      9. Drilling into Data from a Graph
      10. Hyper-Drilling
      11. Drilling Out to Another Worksheet
      12. Drilling Out to a URL
      13. Drilling Out to an Application
      14. Summary
    2. 12 Building Effective Conditions
      1. Adding Conditions
      2. Using Show Values to Add a Condition in Desktop
      3. Adding Conditions Using the Toolbar
      4. Using the Conditions Dialog Box to Add a Condition in Desktop and Plus
      5. The Basic Components of a Condition
      6. Basic Component 1: The Item
      7. Basic Component 2: The Expression
      8. Basic Component 3: The Value
      9. Editing an Existing Condition
      10. Using Advanced Conditions
      11. Creating Conditions Based on Calculations
      12. Creating Conditions Based on Conditions
      13. Using Boolean Operators
      14. Using Subqueries
      15. Removing Conditions
      16. Permanently Removing Conditions
      17. Deactivating a Condition
      18. Removing Columns Upon Which Conditions Are Based
      19. Removing a Database Item Used in Conditions
      20. Removing Calculations Used in Conditions
      21. Deleting Calculations Used in Conditions
      22. Summary
    3. 13 Refining Parameters, Calculations, Sorting, and Percentages
      1. Refining Parameters
      2. Changing a Condition to a Parameter
      3. Creating a Condition from a Parameter
      4. Creating Instant Parameters
      5. Dynamic Parameters
      6. Mandatory and Optional Parameters
      7. Parameter Support for Keywords
      8. Activating and Deactivating Parameters
      9. Cascading Parameters
      10. Editing Parameters
      11. Using Parameters in the Title, Header, or Footer
      12. Refining Calculations
      13. Main Components of a Calculation
      14. Define the Calculation in Advance
      15. Housekeeping after Editing a Calculation
      16. Using Standard Functions in a Query
      17. Calculating Standard Margin and Markup
      18. Activating and Deactivating Calculations
      19. Refining the Sort Order
      20. Sort Order Manipulation
      21. Deleting a Sort Using the Sort tab
      22. Refining Percentages
      23. Using COUNT and Percentages in a Crosstab
      24. Workflow to Change a Percentage
      25. Workflow to Delete a Percentage
      26. Activating and Deactivating Percentages
      27. Summary
    4. 14 Query Management
      1. The Discoverer Manager and the End User
      2. Managing Libraries
      3. Sharing Workbooks with Other Users
      4. Superuser Involvement with Shared Workbooks
      5. How to Share a Workbook
      6. Using a Shared Workbook
      7. Workbook Manipulation
      8. Deleting Workbooks from the Database
      9. Managing Workbook Descriptions and Identifiers
      10. Worksheet Manipulation
      11. Reordering Worksheets
      12. Renaming Worksheets
      13. Deleting Worksheets
      14. Adding a Description to a Worksheet
      15. Copying and Moving Worksheets Between Workbooks
      16. Finding Data in Your Worksheet Results
      17. Scheduling Workbooks
      18. The Benefit of Scheduling Workbooks
      19. How to Schedule a Workbook
      20. How to Share the Results of a Scheduled Workbook
      21. Viewing Results
      22. Unscheduling a Scheduled Workbook
      23. Editing a Scheduled Workbook
      24. Security
      25. Third-Party Scheduling
      26. Running Discoverer Desktop from the Command Line
      27. Running Discoverer from the Command Line
      28. SQL Management
      29. Viewing SQL
      30. Viewing the Explain Plan
      31. Exporting SQL
      32. Importing SQL
      33. Structured SQL
      34. E-Mailing Worksheets and Reports
      35. To Send a Discoverer Workbook via E-Mail
      36. Summary
    5. 15 User Preferences, the Toolbar, and the Discoverer Administrator
      1. Customizing User Preferences
      2. Desktop Options
      3. General
      4. Query Governor
      5. Table/Crosstab
      6. Formats
      7. Cache Settings
      8. Connection
      9. Advanced
      10. EUL
      11. Plus Options
      12. General
      13. Query Governor
      14. Sheet Format
      15. Formats
      16. Advanced
      17. EUL
      18. The Toolbar
      19. The Discoverer Desktop Toolbar
      20. The Discoverer Plus Toolbar
      21. The Discoverer Administrator
      22. The Discoverer Administrator’s Role
      23. You Can Help Your Discoverer Administrator Identify the Data Needed
      24. What Can the Discoverer Administrator Do for You?
      25. Discoverer Desktop Directory Structures
      26. Summary
    6. 16 Introducing Discoverer OLAP
      1. OLAP Background
      2. Oracle Business Intelligence Discoverer Plus for OLAP
      3. Discoverer Plus for OLAP
      4. The Logical Dimensional Model
      5. The Discoverer Catalog
      6. About the Examples
      7. The Global Widgets Logical Dimensional Model
      8. Connecting to Discoverer Plus for OLAP
      9. Creating Your First OLAP Plus Workbook
      10. Exploring the Discoverer Plus for OLAP User Interface
      11. Available Items Pane
      12. OLAP Toolbar
      13. Using the Workbook Wizard to Create OLAP Workbooks
      14. OLAP Worksheet Wizard Step 1
      15. OLAP Worksheet Wizard Step 2
      16. OLAP Worksheet Wizard Step 3: Graph Type
      17. OLAP Worksheet Wizard Step 4: Crosstab Layout
      18. OLAP Worksheet Wizard Steps 5–8: Dimensions
      19. Creating OLAP Conditions or Query Steps
      20. Creating a Query Step Using the Filter Button
      21. Creating Calculations
      22. Creating Totals
      23. Editing Worksheet Properties
      24. Creating Links to Discoverer Worksheets
      25. Creating Relational Workbook Parameters and Conditions
      26. Managing the Discoverer Catalog
      27. Importing BI Beans Crosstabs and Graphs
      28. Summary
  11. Part IV Using the Discoverer Administration Edition
    1. 17 Getting Started in the Administration Edition
      1. Key Definitions
      2. End User Layer
      3. Business Areas
      4. Axes
      5. Item Classes
      6. Hierarchies
      7. Summaries
      8. Properties
      9. Sticky Features
      10. The Steps to a Successful Discoverer Implementation
      11. Understand and Anticipate User Requirements
      12. Create the End User Layer
      13. Create a Business Area
      14. Refine the Business Area
      15. Granting Access to the Business Areas
      16. Deploy
      17. Source to Destination
      18. Source Database
      19. Destination Schema
      20. Creating the End User Layer
      21. New User Privileges
      22. Software Installation
      23. Create the EUL
      24. Creating Your First Business Area
      25. Load Wizard Step 1: Create or Open a Business Area
      26. Load Wizard Step 2: Select the Schema
      27. Load Wizard Step 3: Select the Objects to Use
      28. Load Wizard Step 4: Define the Import Options
      29. Load Wizard Step 5: Name the Business Area and Provide Final Preferences
      30. Key Business Area Objects
      31. Checking a Business Area
      32. Check the Business Area Name, Description, and Identifier
      33. Check the Folder Names, Descriptions, and Identifiers
      34. Check the Order of the Folders
      35. Check the Names of the Items
      36. Check the Order of the Items
      37. Check Default Positions
      38. Check Item Aggregation
      39. Check Default Formats
      40. Summary
    2. 18 Editing the Business Area
      1. Remaining Business Area Checks
      2. Managing Lists of Values
      3. Managing Joins
      4. Enhancing Business Areas
      5. Folder Enhancements
      6. Managing Folder Properties
      7. Hierarchy Enhancements
      8. Item Management
      9. Types of Items
      10. Useful Algorithms
      11. Adding Items to a Complex Folder
      12. Sorting Items
      13. Descriptive Lists of Values: Assigning Indexes to an Item
      14. Summary
    3. 19 Interacting with the End User
      1. Adding New Users
      2. Granting Access to Business Areas
      3. Open Access
      4. Restricted Access and Insider Trading
      5. Workflow to Grant Access
      6. Granting User Edition Privileges
      7. Working with the Privileges Tab
      8. Working with the User/Role or User/Responsibility Tab
      9. Working with the Query Governor Tab
      10. Discoverer Privileges Explained
      11. Adding Meaningful Descriptions to Business Areas, Folders, and Data Items
      12. Adding a Meaningful Description to a Business Area
      13. Adding a Meaningful Description to a Folder
      14. Adding a Meaningful Description to an Item
      15. Adding New Items to Folders
      16. Adding New Items to Simple Folders
      17. Adding New Items to Complex Folders
      18. Adding New Items to Custom Folders
      19. Creating New Folders
      20. Creating Joins Between Folders
      21. Creating Lists of Values
      22. Creating Alternative Sorts
      23. Creating New Items Based on Calculations
      24. Creating New Conditions
      25. Deleting Predefined Conditions
      26. Creating Drill Hierarchies
      27. Modifying an Item’s Type
      28. Creating Summary Data
      29. Rearranging the Order of Folders in a Business Area
      30. Rearranging the Order of Items in a Folder
      31. Changing Refresh Cycles
      32. Allowing Scheduling of Workbooks
      33. Scheduling Privileges
      34. Enabling Scheduling
      35. Storing Workbook Results
      36. Setting up a Scheduled Workbook Results User
      37. Managing Scheduled Workbooks
      38. List of Scheduled Statuses
      39. Creation of New Functions
      40. Working with Optional Arguments
      41. Summary
    4. 20 Configuring Discoverer
      1. Architecture
      2. Oracle HTTP Server (OHS)
      3. Oracle HTTP Server Configuration
      4. Key Oracle HTTP Server Modules
      5. Configuring Oracle HTTP Server Using Oracle Enterprise Manager
      6. Oracle Containers for J2EE (OC4J)
      7. Overview of the OC4J Configuration Files
      8. Configuring OC4J Using Oracle Enterprise Manager
      9. OEM Application Server Control
      10. Configuring Discoverer Using OEM
      11. Discoverer Administration Tab
      12. Discoverer Plus Configuration Page
      13. Discoverer Viewer Configuration Page
      14. Discoverer Portlet Provider Configuration Page
      15. Single Sign-On (SSO)
      16. Configuring Single Sign-On
      17. Enabling Discoverer with SSO
      18. OPMN (Oracle Process Management and Notification)
      19. OPMN Basic Commands
      20. Oracle Internet Directory (OID)
      21. Delegated Administration Service (DAS)
      22. Metadata Repository
      23. Joining a Discoverer Mid-Tier to an Identity Management Server and a Metadata Repository
      24. Discoverer Preferences
      25. Changing Global Preferences Using pref
      26. Changing User Preferences Using the Command Line
      27. Changing User Preferences as a User
      28. Web Cache
      29. Configuring Viewer with Web Cache
      30. Configuring Discoverer for High Availability
      31. Summary
    5. 21 Setting Up Portal for Use with Discoverer
      1. Using Portal
      2. Infrastructure Database
      3. Portal Middle Tier
      4. Configuring the Discoverer Server
      5. Types of Portlet
      6. Analyze Link
      7. Portal Administration
      8. Register the Discoverer Portlet Provider (DPP) with Your Portal Instance
      9. Publish a Discoverer Portlet to Portal
      10. Configuring Discoverer Portlets
      11. Working with Portlets
      12. Using Analyze
      13. Customizing Portlets
      14. Summary
    6. 22 Summary Management
      1. Background
      2. Performance Overview
      3. Summary Setup
      4. Database Setup
      5. Database Privileges
      6. Table Analysis
      7. Materialized Views
      8. Managing Summary Tables
      9. Automated Summary Management (ASM)
      10. Manually Specifying Summaries
      11. Summary Combination Strategy
      12. Using Summary Tables with Oracle Applications
      13. End-User Options
      14. Summary
  12. Part V Appendixes
    1. A Michael’s Gold Mine of Answers to FAQs
    2. B SQL Functions
      1. Standards Used in the Listing
      2. Wildcards
      3. Wildcard Examples
      4. Folders in Discoverer
      5. Alphabetical Listing of Functions
      6. + (Addition)
      7. – (Subtraction)
      8. * (Multiplication)
      9. / (Division)
      10. || (Concatenation)
      11. ABS (Absolute Value)
      12. ACOS
      13. ADD_MONTHS
      14. ASCII
      15. ASCIISTR
      16. ASIN
      17. ATAN
      18. ATAN2
      19. AVG (Average)
      20. AVG_DISTINCT
      21. CASE
      22. CEIL
      23. CHARTOROWID
      24. CHR (Character)
      25. COALESCE
      26. CONCAT
      27. CONVERT
      28. CORR (Correlation)
      29. COS (Cosine)
      30. COSH (Hyperbolic Cosine)
      31. COUNT
      32. COUNT_DISTINCT
      33. COVAR_POP
      34. COVAR_SAMP
      35. CUME_DIST
      36. CURRENT_DATE
      37. DBTIMEZONE
      38. DECODE
      39. DENSE_RANK
      40. DUMP
      41. EUL_DATE_TRUNC
      42. EXP (Exponential)
      43. FIRST_VALUE
      44. FLOOR
      45. GLB
      46. GREATEST
      47. GREATEST_LB
      48. HEXTORAW
      49. INITCAP (Initial Capitals)
      50. INSTR
      51. INSTRB
      52. LAG
      53. LAST_DAY
      54. LAST_VALUE
      55. LEAD
      56. LEAST
      57. LEAST_UB
      58. LENGTH
      59. LENGTHB
      60. LN (Logarithm)
      61. LOG
      62. LOWER
      63. LPAD (Left Pad)
      64. LTRIM (Left Trim)
      65. LUB
      66. MAX (Maximum)
      67. MAX_DISTINCT
      68. MIN (Minimum)
      69. MIN_DISTINCT
      70. MOD (Modulus)
      71. MONTHS_BETWEEN
      72. NEW_TIME
      73. NEXT_DAY
      74. NLSSORT
      75. NLS_INITCAP
      76. NLS_LOWER
      77. NLS_UPPER
      78. NTILE
      79. NULLIF
      80. NUMTODSINTERVAL
      81. NUMTOYMINTERVAL
      82. NVL
      83. NVL2
      84. PERCENTILE_CONT (Percentile Continuous)
      85. PERCENTILE_DISC (Percentile Discrete)
      86. PERCENT_RANK
      87. POWER
      88. RANK
      89. RATIO_TO_REPORT
      90. RAWTOHEX
      91. REGR_xxx (Linear Regression)
      92. REGR_AVGX
      93. REGR_AVGY
      94. REGR_COUNT
      95. REGR_INTERCEPT
      96. REGR_R2
      97. REGR_SLOPE
      98. REPLACE
      99. ROUND (for Dates)
      100. ROUND (for Numbers)
      101. ROWCOUNT
      102. ROWIDTOCHAR
      103. ROWNUM
      104. ROW_NUMBER
      105. RPAD (Right Pad)
      106. RTRIM (Right Trim)
      107. SESSIONTIMEZONE
      108. SIGN
      109. SIN (Sine)
      110. SINH (Hyperbolic Sine)
      111. SOUNDEX
      112. SQRT (Square Root)
      113. STDDEV (Standard Deviation)
      114. STDDEV_DISTINCT (Distinct Standard Deviation)
      115. STDDEV_POP
      116. STDDEV_SAMP
      117. SUBSTR (Substring)
      118. SUBSTRB
      119. SUM
      120. SUM_DISTINCT
      121. SUM_SQUARES
      122. SYSDATE (System Date)
      123. TAN (Tangent)
      124. TANH (Hyperbolic Tangent)
      125. TO_CHAR (Dates)
      126. TO_CHAR (Labels)
      127. TO_CHAR (Numbers)
      128. TO_DATE
      129. TO_LABEL
      130. TO_MULTI_BYTE
      131. TO_NUMBER
      132. TO_SINGLE_BYTE
      133. TRANSLATE
      134. TRUNC (Dates)
      135. TRUNC (Numbers)
      136. UID
      137. UPPER
      138. USER
      139. USERENV
      140. VARIANCE
      141. VARIANCE_DISTINCT
      142. VAR_POP (Population Variance)
      143. VAR_SAMP (Sample Variance)
      144. VSIZE
      145. WIDTH_BUCKET
      146. Time Zones
      147. Using Formats When Rounding Dates
      148. Date Format Masks
      149. Day Format Masks
      150. Month Format Masks
      151. Year Format Masks
      152. Other Date Masks
      153. Time Format Masks
      154. Special Format Masks
      155. Prefixes and Suffixes
      156. Number Format Masks
      157. ASCII Character Set
      158. Analytic Functions
      159. What Are Analytic Functions?
      160. Essential Concepts
      161. Using Analytic Functions
      162. Editing Analytical Functions
      163. Windowing Options
      164. The Power of Analytics
      165. Summary
    3. C Databases and Views
      1. Database Schemas
      2. Relational Schemas
      3. Star Schemas
      4. Accessing Oracle Applications Using Discoverer
      5. Oracle Applications Business Views
      6. NoetixViews
      7. Company-Built Views
      8. Summary
    4. D Tutorial Database
      1. Entity-Relationship Diagram for the Global Widgets Sales Database
      2. The Global Widgets Tables
      3. GS_SALES
      4. GS_CHANNEL
      5. GS_PRODUCTS
      6. GS_PRODLINE
      7. GS_CUSTOMER
      8. GS_CITY
      9. GS_DISTRICT
      10. GS_REGION
      11. Fiscal Time
      12. GS DAY
      13. GS MONTH
      14. GS QUARTER
      15. GS YEAR
      16. Entity-Relationship Diagram for the Fan Trap
      17. The Fan Trap Tables
      18. FAN_DEPARTMENT
      19. FAN_BUDGET
      20. FAN_EXPENSES
      21. Summary
  13. Index