SAVEPOINT statements, 152, 154
schema, defined, 35, 160
scripts
defined, 180
reporting and, 195–198, 196–197
security, 223–239
auditing, 234–237
object auditing, 236–237
statement auditing, 234–236
Change Password and, 184
creating user accounts and, 224–227
assigning passwords, 224–225
default tablespaces and quotas, 226–227, 227
profiles, 225–226
privileges, 227–234
object privileges, 229–231
roles, 232–234, 232
system privileges, 228–229
segments, 158, 159
SELECT clause, vs. WHERE clause, 72
SELECT statement, 25–29
column renaming and, 27
column specification and, 25–27, 26
duplicate removal and, 27–28
expressions and, 28–29
retrieval of rows and, 17–18, 18
user-defined views and, 211–212
self-joins, 111–113
sequences, creating, 217–218
set operators, 126–130, 126–134
INTERSECT, 130–132
MINUS, 132–134
UNION and UNION ALL, 126–130
SGA (System Global Area), 163, 163
shared pool, defined, 67, 164
SIDs (system identifiers), defined, 172
single-row subqueries, 120–121
SMON (System Monitor), 163, 166
Software Code Area, 165
software, installing Oracle, 166–170
OEM and, 169–170, 170
OUI and, 166–169, 167–169
SPFILEs, 262
spreadsheets vs. databases, 2–3
SQL. See Structured Query Language (SQL)
SQL Server
basics of, 329
vs. Oracle database platforms, 328
SQL*Plus
basics of, 15–18, 16–17
vs. iSQL*Plus, 19–20
system variables, defined, 182
SQL*Plus Worksheet
basics of, 21, 21
system variables, defined, 182
statements
auditing, 234–236
failures of, 268
statistics, and cost-based optimizer, 259–260
storage
logical storage structures, 158–160, 158
physical storage structures, 160–162, 161
stored functions, defined, 65, 67
strings
concatenating, 49–50
string functions, built-in, 52–55
string literals, 49–50
Structured Query Language (SQL), 4, 13–43
application tuning, 256–261
Explain Plan tool, 257–258, 258
Oracle optimizer, 258–261
Top SQL tool, 256–257, 256–257
DCL, 40–41
GRANT statement, 40
REVOKE statement, 41
DDL, 34–39
ALTER statement, 37–38
CREATE statement, 35–37, 36
DROP statement, 38
RENAME statement, 38–39
TRUNCATE statement, 39
defined, 14
DML, 29–34
DELETE statement, 33, 33
INSERT statement, 32–33
MERGE statement, 34
UPDATE statement, 30–31, 30–31
SELECT statement, 25–29
column renaming, 27
column specification, 25–27, 26
duplicate removal, 27–28
expressions, 28–29
tools for running, 14–24
iSQL*Plus, 18–20, 19–20
OCI, 24
ODBC/JDBC, 22–24, 23
SQL*Plus, 15–18, 16–17
SQL*Plus Worksheet, 21, 21
third-party tools, 21
subqueries, 120–126
correlated, 123–124
multiple-column, 125–126
multiple-row, 121–123
single-row, 120–121
substitution variables, and reporting, 192–195, 193–194
summary operations, and report formatting, 191–192
Sybase’s Adaptive Server Enterprise, 329
synonyms
creating, 219
for data dictionary views, 215
syntax
for CTAS, 203
italics in, 24
uppercase in, 24
System Global Area (SGA), 163, 163
system identifiers (SIDs), defined, 172
System Monitor (SMON), 163, 166
system privileges, 228–229
system trace files, 296–297, 297
system variables, and reporting, 182–184