Crystal Reports 9 on Oracle (Database Professionals) - page 1
- 1
- 2
- Table of Contents
- Table of Contents
- BackCover
- Crystal Reports 9 on Oracle
- Introduction
- Chapter 1: Connectivity, Authentication, and Privileges
- Choosing a Connection Method
- Crystal Database Options
- User IDs and Schemas
- Authentication Methods
- Database Privileges
- Connection Options Used in Book
- Chapter 2: Oracle Structures
- Objects
- Relationships
- Datatypes
- Nulls
- Data Dictionary Views
- Chapter 3: Oracle SQL
- SELECT List
- FROM Clause
- Join Types
- Filtering
- Ordering
- Grouping
- Group Filtering
- Operators
- Oracle Comparison Conditions
- Aggregation
- Working with Dates
- Working with Strings
- Working with Numbers
- Other Common Functions
- Pseudo Columns
- Subqueries
- Chapter 4: Oracle Advanced SELECT Options
- Set Operations
- Hierarchical Queries
- WITH Clause
- Aggregation
- Analysis
- Chapter 5: PLSQL
- PLSQL Structures
- REF CURSOR Stored Procedures
- Chapter 6: Optimizing: The Crystal Reports Side
- Miscellaneous Hints
- SQL Expressions
- SQL Commands
- Chapter 7: Optimizing: The Oracle Side
- Execution Plans
- Execution Plan Subreport
- Optimizing the Environment
- Optimizing the Execution Plan
- Chapter 8: Optimizing: Reducing Parses
- Description of Parsing
- Reducing Hard Parsing
- Caching Cursors
- Chapter 9: Other Tips
- External Tables
- Heterogeneous Services: Generic Connectivity
- Oracle Flashback Query
- Updating Data via Crystal Reports
- Chapter 10: Data Dictionary Report
- Oracle Data Dictionary Views
- Report Strategy
- Creating the Query
- Creating the Report
- Chapter 11: The Crystal Repository
- Configuring Security for the Repository
- Using the Repository
- A Repository Report
- Appendix A: Common Issues
- Appendix B: Functions
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- 1
- 2
