O

object actions, XForms , 344345

object model

abstraction, 232

attributes, 231

classes, 231

collections, 231

data structure, 225226

document comparison, 238

end of chapter exercise, 242243

ERDs, 232

flat data, 227229, 237

inheritance, 231

inter--relationships, 226

layered structure, 235236

many--to--many relationship, 226, 232, 234

methods , 231, 235

normalized structure, 226, 231

one--to--many relationship, 226

relational structure, 226230

sample database, 430

specializations, 232

objects, DOM

classes versus, 32

hierarchical structure, 3031

HTTPRequest , 5051

OLAP (Online Application Processing) , 104

ON clause, JOIN clause, 106

one--to--many relationship, object model , 226

open standards, XML advantages , 3

opening tags

how to use, 2

syntax rules, 14

OPENROWSET function, 185

OPENXML function, 183184

operators, XPath scripting language , 275276

optional ([ ]) character , 431

OR logical operator, 9394

Oracle database

browser--based control tools, 161

document creation

content, editing and removing, 159161

database storage, 153154

demographics , 153154

document retrieval, 154155

duplicated records, 142

file size considerations, 143

GROUP BY clause, 144

highlighted name example, 137

methods, list of, 135

multiple fields, 141

nested tables, 145

relational structure form, 140

results, reading, 155159

root tag, 145

sorting order example, 139

tag creation, 136

white space removal, 138

end of chapter exercise, 162163

GUI (Graphical User Interface), 161

packages, 134

PL/SQL package, 151153

SYS_XMLGEN function, 146

TYPE objects, 147

user--defined types, 146

XML document creation, 134135

XMLType data type

CLOB object, 132

discussed, 131

methods, 132133

subprograms, 132

uses for, 132

XQuery language support, 311312

ORDER BY clause

AS clause in, 101102

defined, 88

FLWOR statement, 307308

functionality, 100

WHERE clause, 102

order of data, XML advantages , 3

order--by attribute

xsl:apply--template element, 64

xsl:for--each element, 71

outer joins , 109110