Index_S


S

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




Oracle9i DBA JumpStart
Oracle9i DBA JumpStart
ISBN: 0782141897
EAN: 2147483647
Year: 2006
Pages: 138
Authors: Bob Bryla

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