Index_O


O

object identifiers, 372
object privileges, 277 “285
checking, 278 “280
commonly used, 278
granting to a user , 278
making use of, 282 “283
revoking, 284 “285
object privileges granted to a role, checking, 288 “289
object privileges received, checking, 280 “282
object references, 372
object tables, defining, 372
object types
column objects and object tables, 371 “372
creating, 368 “370
explained, 368
getting information on, 370 “371
object_customers table
DML on, 376 “378
inserting rows into, 377
selecting rows from, 377 “378
object_products table
deleting rows in, 376
DML on, 375 “376
inserting rows into, 375
selecting rows from, 375 “376
updating rows in, 376
object_product.sql, 380
objects (database), 367 “388
id attribute for, 373, 377
introduction to, 368
using in PL/SQL, 380 “381
object_schema2.sql, 382
object_schema.sql, 369
OCI driver (JDBC), 480
OID (object identifier), 372 “373
ON clause
with INNER JOIN, 55, 59
with inner joins, 55, 57, 59
with non- equijoins , 55
ON COMMIT clause of CREATE TABLE, 294
ON COMMIT PRESERVE ROWS, 295
ON DELETE CASCADE clause, 302 “303
ON DELETE SET NULL clause, 303
OPEN statement ( cursors ), 338
OPEN() function, 466 “467
operator precedence, 43
of arithmetic operators, 33
use of parentheses, 33
optimizer execution plans, comparing, 541 “548
optimizer hints, 548 “549
optimizer subsystem, 541
OR logical operator, 42
AND operator precedence over, 43
outer joins and, 53
ORA-00001 error (unique constraint violated), 253
ORA-00934 error ( group function not allowed here),  97
ORA-00937 error (not a single-group function), 96
ORA-00942 error (table or view does not exist), 283 “284
ORA-01017 error (invalid username/password), 508
ORA-01031 error (insufficient privileges), 277
ORA-01427 error (single-row subquery returns more than one row), 170
ORA-02291 error (integrity constraint violated), 254
ORA-02292 error (integrity constraint violated), 254
Oracle Advisors, 550
Oracle Corporation, 3
Oracle data source, to connect to a database, 484 “487
Oracle data source object, creating, 484
Oracle data source object attributes, setting, 484 “486
Oracle data types, 551 “556
Oracle Database 10g enhancements
automatic gathering of statistics, 542
to collections, 414 “425
to LOBs, 471 “473
new MODEL clause, 235 “244
new types, 22 “24
Oracle database types, common, 11 “13
Oracle Enterprise Manager Diagnostics Pack, 549
Oracle extensions to JDBC, 481, 514 “526
ORACLE_HOME directory, 477
ORACLE_HOME directory subdirectories, 476
ORACLE_HOME environment variable, 477 “478
Oracle and Java types, 488 “490
Oracle JDBC drivers, 480 “481
four types of, 480
registering, 481
Oracle Net TNSNAMES string, 483
Oracle PL/SQL types, 555 “556
Oracle Reports (software), 158
Oracle SQL types, 552 “555
Oracle System Identifier (SID), 482 “483
Oracle9i JDBC Programming, 4, 476, 514
Oracle_10g_examples.sql, 24
OracleDataSource attributes, table of, 485
OracleDataSource class, 484
oracle.jdbc package, 515, 519 “523
oracle.jdbc package classes and interfaces, 519 “520
oracle.jdbc.pool.OracleDataSource class, 484
OraclePreparedStatement interface, 520
OracleResultSet interface, 522
oracle.sql classes mapped to Oracle database types,  516
oracle.sql package, 515 “519
CHAR class, 517 “518
CharacterSet class, 517
DATE class, 518
NUMBER class, 516 “517
ROWID class, 519
ORDER BY clause, 184 “185, 206
with DESC or ASC, 44
in sorting groups, 95 “96
in sorting rows and columns , 43 “44
subqueries and, 170 “171
ordinary-least-squares regression line, 233
OTHERS exception, 346 “347
OUT parameter mode, 348
OUTER JOIN, 58
outer join operator ((+)), 50 “54
outer joins, 49 “54
in combination with self joins, 54
and the IN operator, 53
limitations of, 53 “54
and the OR operator, 53
using SQL/92, 58
OVER clause, 217
DESC or ASC in, 217
with SUM(), 230 “231



Oracle Database 10g SQL
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
Year: 2004
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net