Acknowledgments |
|
xii | |
Introduction |
|
xv | |
Chapter 1 Connectivity, Authentication, and Privileges |
|
1 | (28) |
|
|
2 | (18) |
|
Database Administrator Tasks |
|
|
2 | (1) |
|
Installation of Oracle Components |
|
|
3 | (7) |
|
Installation of the Crystal XTREME Sample Data |
|
|
10 | (4) |
|
Installation of the Crystal Data Access Components |
|
|
14 | (1) |
|
Configuration of the Native Oracle OCI |
|
|
15 | (1) |
|
|
16 | (1) |
|
|
16 | (4) |
|
Choosing a Connection Method |
|
|
20 | (4) |
|
|
24 | (2) |
|
|
24 | (2) |
|
|
26 | |
|
|
21 | (1) |
|
|
21 | (7) |
|
Connection Options Used in Book |
|
|
28 | (1) |
Chapter 2 Oracle Structures |
|
29 | (30) |
|
|
30 | (1) |
|
|
30 | (9) |
|
|
30 | (2) |
|
|
32 | (1) |
|
|
33 | (1) |
|
|
34 | (1) |
|
|
34 | (1) |
|
|
35 | (1) |
|
|
35 | (3) |
|
|
38 | (1) |
|
|
38 | (1) |
|
|
39 | (3) |
|
|
42 | (12) |
|
|
42 | (7) |
|
|
49 | (2) |
|
|
51 | (3) |
|
|
54 | (1) |
|
|
55 | (1) |
|
|
55 | (4) |
Chapter 3 Oracle SQL |
|
59 | (26) |
|
|
60 | (1) |
|
|
61 | (1) |
|
|
62 | (1) |
|
|
62 | (8) |
|
|
65 | (2) |
|
|
67 | (3) |
|
|
70 | (1) |
|
|
71 | (1) |
|
|
71 | (1) |
|
|
72 | (1) |
|
|
72 | (1) |
|
Oracle Comparison Conditions |
|
|
73 | (1) |
|
|
73 | (2) |
|
|
75 | (2) |
|
Dates in the Selection formula |
|
|
76 | (1) |
|
Date Literals in SQL Expressions |
|
|
76 | (1) |
|
|
76 | (1) |
|
|
77 | (1) |
|
|
78 | (1) |
|
|
79 | (2) |
|
|
79 | (1) |
|
|
79 | (1) |
|
|
79 | (1) |
|
|
80 | (1) |
|
|
80 | (1) |
|
|
80 | (1) |
|
|
81 | (1) |
|
|
81 | (1) |
|
|
81 | (1) |
|
|
82 | (1) |
|
|
82 | (3) |
Chapter 4 Oracle Advanced SELECT Options |
|
85 | (36) |
|
|
86 | (2) |
|
|
88 | (3) |
|
|
88 | (1) |
|
|
89 | (1) |
|
|
89 | (2) |
|
|
91 | (1) |
|
|
91 | (1) |
|
|
92 | (1) |
|
|
93 | (3) |
|
|
95 | (1) |
|
|
95 | (1) |
|
|
96 | (25) |
|
|
96 | (6) |
|
Reporting Aggregate functions |
|
|
102 | (2) |
|
Windowing Aggregate Functions |
|
|
104 | (6) |
|
FIRST_VALUE and LAST_VALUE |
|
|
110 | (1) |
|
|
111 | (1) |
|
|
112 | (2) |
|
|
114 | (2) |
|
|
116 | (2) |
|
Hypothetical Rank and Distribution |
|
|
118 | (1) |
|
|
119 | (2) |
Chapter 5 PL/SQL |
|
121 | (32) |
|
|
122 | (1) |
|
|
123 | (14) |
|
|
123 | (4) |
|
|
127 | (1) |
|
REF CURSORS (Cursor Variables) |
|
|
128 | (1) |
|
|
129 | (1) |
|
|
129 | (6) |
|
|
135 | (1) |
|
|
136 | (1) |
|
|
136 | (1) |
|
REF CURSOR Stored Procedures |
|
|
137 | (16) |
|
Stored Procedure Requirements |
|
|
138 | (2) |
|
Simple Stored Procedure Example |
|
|
140 | (2) |
|
Privileges for REF CURSOR Stored Procedures |
|
|
142 | (1) |
|
Stored Procedure Parameters and Crystal |
|
|
143 | (3) |
|
|
146 | (1) |
|
Calling Stored Procedures from SQL Commands |
|
|
146 | (2) |
|
|
148 | (1) |
|
Issues with Stored Procedures |
|
|
149 | (4) |
Chapter 6 Optimizing: The Crystal Reports Side |
|
153 | (52) |
|
Reducing the Number of Records |
|
|
154 | (6) |
|
|
154 | (3) |
|
Using SQL Expressions in Selection formulas |
|
|
157 | (3) |
|
|
160 | (1) |
|
|
160 | (4) |
|
|
160 | (2) |
|
|
162 | (1) |
|
Use Union All Instead of Union |
|
|
162 | (1) |
|
Avoid Sort in Specified Order |
|
|
162 | (1) |
|
|
162 | (1) |
|
Avoid linking Stored Procedure Datasets to Other Objects |
|
|
163 | (1) |
|
|
163 | (1) |
|
|
164 | (36) |
|
|
166 | |
|
|
114 | (83) |
|
|
197 | (3) |
|
|
200 | (5) |
|
SQL Allowed in SQL Commands |
|
|
200 | (1) |
|
|
201 | (1) |
|
|
202 | (1) |
|
|
203 | (2) |
Chapter 7 Optimizing: The Oracle Side |
|
205 | (38) |
|
|
206 | (2) |
|
|
206 | (1) |
|
|
207 | (1) |
|
|
208 | (11) |
|
Displaying Execution Plans |
|
|
208 | (1) |
|
|
209 | (5) |
|
|
214 | (4) |
|
|
218 | (1) |
|
|
218 | (1) |
|
|
218 | (1) |
|
|
218 | (1) |
|
|
219 | (4) |
|
Optimizing the Environment |
|
|
223 | (6) |
|
Optimizer Initialization Parameters |
|
|
223 | (2) |
|
|
225 | (4) |
|
Optimizing the Execution Plan |
|
|
229 | (14) |
|
|
229 | (2) |
|
|
231 | (7) |
|
|
238 | (3) |
|
|
241 | (2) |
Chapter 8 Optimizing: Reducing Parses |
|
243 | (32) |
|
|
244 | (1) |
|
|
245 | (21) |
|
Looking at Oracle's V$SQL Dynamic Performance View |
|
|
245 | (1) |
|
Crystal Parameters and Parsing |
|
|
246 | (1) |
|
Subreport for SQL Statistics |
|
|
247 | (6) |
|
|
253 | (1) |
|
|
254 | (1) |
|
Stored Procedures and Parsing |
|
|
255 | (3) |
|
|
258 | (3) |
|
|
261 | (4) |
|
Choosing a Parse Reduction Method |
|
|
265 | (1) |
|
|
266 | (9) |
Chapter 9 Other Tips |
|
275 | (28) |
|
|
276 | (10) |
|
|
276 | (6) |
|
|
282 | (3) |
|
|
285 | (1) |
|
|
286 | (2) |
|
|
286 | (1) |
|
|
287 | (1) |
|
Heterogeneous Services: Generic Connectivity |
|
|
288 | (5) |
|
|
288 | (3) |
|
|
291 | (1) |
|
|
292 | (1) |
|
|
293 | (8) |
|
|
294 | (1) |
|
SELECT AS OF a Point in the Past |
|
|
295 | (1) |
|
Reporting Using SELECT AS OF |
|
|
296 | (2) |
|
|
298 | (3) |
|
Updating Data via Crystal Reports |
|
|
301 | (2) |
|
|
301 | (1) |
|
|
301 | (2) |
Chapter 10 Data Dictionary Report |
|
303 | (18) |
|
Oracle Data Dictionary Views |
|
|
304 | (1) |
|
|
304 | (2) |
|
|
306 | (7) |
|
|
307 | (2) |
|
|
309 | (2) |
|
|
311 | (1) |
|
|
312 | (1) |
|
|
313 | (8) |
|
|
313 | (1) |
|
|
314 | (3) |
|
|
317 | (1) |
|
|
317 | (1) |
|
|
317 | (1) |
|
|
318 | (1) |
|
Populate and Format the Sections |
|
|
318 | (3) |
Chapter 11 The Crystal Repository |
|
321 | (38) |
|
|
328 | (9) |
|
Creating the Oracle Schema |
|
|
328 | (1) |
|
Creating the Repository Tables |
|
|
329 | (3) |
|
|
332 | (2) |
|
Populating Repository Sample Data |
|
|
334 | (2) |
|
Configuring Crystal to Use the New Repository |
|
|
336 | (1) |
|
Test the New Repository Tables |
|
|
336 | (1) |
|
Configuring Security for the Repository |
|
|
337 | (17) |
|
Understanding the Repository Data Model |
|
|
337 | (2) |
|
Determining Security levels |
|
|
339 | (3) |
|
Implementing Repository Security |
|
|
342 | (12) |
|
|
354 | (1) |
|
|
355 | (4) |
Appendix A Common Issues |
|
359 | (2) |
|
|
360 | (1) |
|
|
361 | (3) |
|
|
364 | |
Appendix B Functions |
|
361 | (12) |
|
Reproducing Crystal functions |
|
|
368 | (1) |
|
|
369 | (4) |
Index |
|
373 | |