|
Critical Skill 8.3 SQLX: Create XML from Data Stored in Oracle |
276 |
|
The SQL/XML Standard |
276 |
|
xmlelement() |
277 |
|
xmlattributes() |
277 |
|
xmlforest() |
277 |
|
xmlagg() |
279 |
|
Project 8-1 Creating an XML Listing |
281 |
|
Critical Skill 8.4 Store XML in Oracle XML DB |
283 |
|
The Native XML Type |
283 |
|
The XML DB Repository |
284 |
|
Registering an XML Schema |
284 |
|
Loading XML Data |
286 |
|
Project 8-2 Storing XML |
287 |
|
Use the RESOURCE_VIEW |
288 |
|
Path-Based Access |
289 |
|
Update the XML Document |
290 |
|
Critical Skill 8.5 Use Simple Queries |
291 |
|
Project 8-3 Using Simple Queries |
293 |
|
Critical Skill 8.6 Create a Relational View from XML |
294 |
|
Critical Skill 8.7 Learn Programmatic Access Using XSLT |
296 |
|
Chapter 8 Mastery Check |
297 |
|
9 Large Database Features |
299 |
|
Critical Skill 9.1 What Is a Large Database? |
300 |
|
Critical Skill 9.2 Why and How to Use Data Partitioning |
301 |
|
Why Use Data Partitioning |
301 |
|
Implement Data Partitioning |
305 |
|
Project 9-1 Creating a Range-Partitioned Table and a Local Partitioned Index |
320 |
|
Critical Skill 9.3 Compress Your Data |
323 |
|
Data Compression |
324 |
|
Index Key Compression |
326 |
|
Critical Skill 9.4 Use Parallel Processing to Improve Performance |
327 |
|
Parallel Processing Database Components |
327 |
|
Parallel Processing Configuration |
328 |
|
Invoke Parallel Execution |
330 |
|
Critical Skill 9.5 Use Materialized Views |
331 |
|
Uses for Materialized Views |
332 |
|
Query Rewrite |
333 |
|
When to Create Materialized Views |
334 |
|
Create Materialized Views |
335 |
|
Critical Skill 9.6 Real Application Clusters: A Primer |
336 |
|
RAC Architecture |
337 |
|
