Oracle PL(s)SQL For DBAs

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

salt, TDE and

SAVEPOINT statement

savepoints 2nd

schedule_limit attribute

schedule_name attribute 2nd

SCHEDULE_NAME column 2nd 3rd

schedule_name parameter

     CREATE_JOB procedure 2nd 3rd

     CREATE_SCHEDULE procedure

     CREATE_WINDOW procedure

     DROP_SCHEDULE procedure

     scheduling 2nd

SCHEDULE_OWNER column 2nd 3rd

SCHEDULE_TYPE column 2nd

SCHEDULER$_EVENT_LOG table

SCHEDULER$_JOB_RUN_DETAILS table

schedules

     defined 2nd

     managing

     managing attributes

     named 2nd 3rd

     overlapping

     ownership

     packages and

     schedule_name parameter and

     windows and 2nd 3rd

scheduling

     components of 2nd

     jobs from Oracle

     managing attributes

     managing calendars

     managing jobs

     managing logging

     managing named programs

     managing priorities

     managing schedules

     managing windows

schemas

     administering FGA

     functions

     policies and

     procedures and

     trusted procedures

scientific notation

SCN (System Change Number) 2nd 3rd

SCN column 2nd

sec_relevant_cols parameter (ADD_POLICY) 2nd

sec_relevant_cols_opt parameter (ADD_POLICY) 2nd

secret key

security

     accountability 2nd

     application contexts

     encryption and 2nd

     importance of

     job scheduling and

     key length and

     key management and

     salt and

SEED function

seed parameter (DES3GETKEY)

seed_string parameter (DES3GETKEY) 2nd

seeding 2nd 3rd

SEL column 2nd 3rd 4th

SELECT FOR UPDATE statement

SELECT INTO clause

     BULK COLLECT clause and

     implicit cursors 2nd 3rd

SELECT privilege

SELECT statement

     as parameter

     auditing and 2nd 3rd

     bind variables and

     collections as parameters

     CURSOR expression

     CURSOR keyword

     cursor variables

     cursors and

     EXECUTE IMMEDIATE statement

     explicit cursors

     FGA and 2nd

     FOR loop and

     functions and

     implicit cursors 2nd

     INSERT statement and

     package body and

     predicates and

     results sets

     SYS_REFCURSOR datatype and

     table functions 2nd 3rd 4th

     triggers and 2nd

     using natively

     VALUE function

semicolon (;)

     as delimiter

     blocks and

     dynamic PL/SQL

     EXECUTE IMMEDIATE statement

     procedure calls

     symbol functionality

sequential control statements

SERVERERROR trigger 2nd

service attribute

SERVICE column

service parameter (CREATE_JOB_CLASS) 2nd

SERVICE_NAME column

SERVICE_NAME parameter

SESSION_ID column 2nd 3rd

SET TRANSACTION statement

SET_ATTRIBUTE procedure

SET_CONTEXT function

set_dept_ctx procedure 2nd 3rd 4th

SET_IDENTIFIER function

SGA (System Global Area) 2nd 3rd

SHA-1 (Secure Hash Algorithm 1)

     cryptographic hashing 2nd 3rd 4th

     functionality

     MAC and 2nd

     support for

shared pool, cursors and

shared static policy 2nd

SHUTDOWN trigger 2nd

similar matching

SIMILAR setting (ALTER SESSION) 2nd

single-line comments

SLAVE_OS_PROCESS_ID column

SLAVE_PID column

SLAVE_PROCESS_ID column

soft parsing

soft-closing cursors 2nd

spoofing, encryption and

SQL Trace

SQL%FOUND attribute 2nd

SQL%ISOPEN attribute

SQL%NOTFOUND attribute 2nd

SQL%ROWCOUNT attribute 2nd 3rd

SQL*Loader

SQL*Plus 2nd

SQL_BIND column 2nd 3rd 4th

SQL_ID column

SQL_TEXT column 2nd 3rd 4th

SQLASTPlus environment

SQLCODE function

SQLERRM function

square brackets []

src parameter

     DECRYPT program

     ENCRYPT program

     HASH function

     MAC function

STANDARD package (PL/SQL) 2nd

start_date attribute 2nd

START_DATE column 2nd 3rd 4th

start_date parameter

     CREATE_JOB procedure 2nd

     CREATE_SCHEDULE procedure

     CREATE_WINDOW procedure

     EVALUATE_CALENDAR_STRING procedure

START_SCN column 2nd

START_TIMESTAMP column 2nd

STARTUP trigger 2nd

STATE column 2nd

STATEMENT_TYPE column 2nd

statement_types parameter (ADD_POLICY) 2nd 3rd 4th

STATEMENTID column

static policies 2nd

static SQL

STATIC_POLICY column

static_policy parameter (ADD_POLICY) 2nd 3rd

statistical patterns

STATUS column 2nd 3rd

STOP_JOB function

STOP_JOB procedure 2nd

stop_on_window_close attribute

stop_on_window_close parameter (CREATE_JOB)

streaming cipher 2nd

STRING function

     functionality 2nd

     parameters 2nd

     strings of random length 2nd

string literals

STRING_TO_RAW function 2nd 3rd

strings

     BULK COLLECT clause

     calendar

     DBMS_RANDOM package

     generating 2nd

     generating random lengths 2nd

     passing

strong types

     cursor variables

     defined

     REF cursors

     SELECT statement

symmetric encryption 2nd

syntax elements

     block structure

     character set

     comments 2nd

     identifiers

     literals

     semicolon delimiter

SYS user 2nd 3rd

SYS_CONTEXT function 2nd

SYS_REFCURSOR datatype

     examples 2nd 3rd

     table functions and

SYSAUX tablespace

System Change Number (SCN) 2nd 3rd

SYSTEM column 2nd

System Global Area (SGA) 2nd 3rd

SYSTEM tablespace