data, 71–93
group functions and, 85–91
basics of, 85–87
GROUP BY clause, 87–89
HAVING clause, 90–91
NVL and, 89
ORDER BY clause and, 83–84
@Index2:validating in columns. See constraints
Where clause and, 72–82
BETWEEN, 76–78
IN, 79–80
AND, OR, and NOT, 74–76
comparison conditions, 72–74
IS NULL and IS NOT NULL, 81–82
LIKE, 80–81
@Index1:Data Control Language (DCL), 40–41
GRANT statement, 40
REVOKE statement, 41
Data Definition Language (DDL), 34–39
ALTER statement, 37–38
CREATE statement, 35–37, 36
DROP statement, 38
RENAME statement, 38–39
TRUNCATE statement, 39
data design tuning, 251–255
materialized views and, 254–255
Oracle’s Tuning Methodology and, 242
partitioned tables and, 251–254
data dictionary views
basics of, 212–215
index information, 250–251
Data Manipulation Language (DML), 29–34
DELETE statement, 33, 33
INSERT statement, 32–33
MERGE statement, 34
UPDATE statement, 30–31, 30–31
data modeling, and relational databases, 6–9
database administrators. See DBAs
Database Configuration Assistant (DBCA)
basics of, 171–176, 171–176
tablespaces and, 159
database objects, 201–221
auditing, 236–237
backing up, RMAN, 284
indexes, creating, 208–210
object views, defined, 10
privileges, 229–231
sequences, creating, 217–218
synonyms, creating, 219
tables, creating, 202–210
Create Table As Select (CTAS), 203–205
external tables, 205–207
relational tables, 202–203
temporary tables, 208
views, 10, 210–217
data dictionary, 212–215
dynamic performance, 215–217
user-defined, 210–212
Database Writer (DBWn), 163, 165
databases, 1–11. See also Oracle database functions; Oracle database installation and creation
blocks, 160
buffer cache, 163, 163
duplicating, and RMAN, 285
failures, 268
history of Oracle, 328
object-relational databases, 9–10
platforms, 328–330
enterprise databases, 328–329
personal and freeware databases, 330
relational databases, 3–4
data modeling, 6–9
primary keys, datatypes and foreign keys, 5–6
tables, rows and columns, 4
spreadsheets vs., 2–3
datafiles, 161, 161
datatypes
abstract, 9
relational databases and, 5–6
date functions, built-in, 58–60
DBA_ data dictionary views, 212
DBA_IND_COLUMNS, 251
DBA_INDEXES data dictionary views, 250–251
DBAs
backup and recovery methods, 276–285
cold backups, 281
Export and Import utilities, 276–281, 277
hot backups, 281–282
Log Miner, 282–284, 283–284
Recovery Manager (RMAN), 284–285, 285
DBA privileges, listed, 228
DBCA (Database Configuration Assistant)
basics of, 171–176, 171–176
tablespaces and, 159
DBWn (Database Writer), 163, 165
DCL (Data Control Language), 40–41
GRANT statement, 40
REVOKE statement, 41
DDL. See Data Definition Language (DDL)
default tablespaces, assigning, 226–227
DELETE statement
DML and, 33, 33
vs. TRUNCATE statement, 39
DESCRIBE statement, 211
directories, defined, 206
dirty buffers, 163–164
disk and memory requirements, 171
DISTINCT keyword, 27–28, 86
DML. See Data Manipulation Language (DML)
DROP statement, 38
DUAL tables, 46–48, 47
dynamic performance views, 215–217