SecureFiles 15 395 930
SecureFiles, BasicFiles versus 415
SecureFiles, compression 416
SecureFiles, deduplication 416
SecureFiles, encryption 417
Security 919 see
Security in application contexts 966
security policies see "Policies"
Security, enhancements for DBMS_SQL package 558
SELECT FOR UPDATE statements 466 492—496
SELECT FOR UPDATE statements, releasing locks with COMMIT 494
SELECT FOR UPDATE statements, WHERE CURRENT OF clause 495
SELECT statements, explicit cursor 477
SELECT statements, explicit cursor body 481
SELECT statements, implicit cursor 472
Selection directives 999
SELF keyword 1082
Sequences in expressions 14
Sequences, native PL/SQL support for in Oracle Database 11g 442
Sequential control statements 81
Sequential control statements, GOTO 97
SERIALIZABLE isolation level 457
SERIALLY_REUSABLE pragma 76 640
SERVERERROR triggers 683 686—690
SERVERERROR triggers, central error handler 689
SERVERERROR triggers, examples of 687
SERVEROUTPUT command (SQLTlus) 28
Session persistence with packages 622
Sessions, caching static data 629 649
Sessions, database 983
Sessions, package data as global within 634
SESSIONTIMEZONE function 273
SET command (SQL*Plus) 32
SET DEFINE OFF command (SQL*Plus) 196
SET ECHO ON command (SQL*Plus) 39
SET EDITFILE command (SQL*Plus) 34
Set operations see "Nested tables multiset
SET TRANSACTION statements 453
SET TRANSACTION statements, isolation level of SERIALIZABLE 457
Set-based MERGE, using pipelined functions 847
Severe compile-time warnings 736
SFTK timer package 789
SGA (System Global Area) 362 782
SGA (System Global Area), data caching in 799
SHA-1 (Secure Hash Algorithm) 939
Shared context-sensitive policies 957
Shared server 1010
Shared static policies 955
short-circuit evaluation 89
SHOW ERRORS command (SQL**Plus) 40
SHOW ERRORS command (SQL**Plus), list of categories recognized by 40
SHUTDOWN triggers 683 685
Signature mode (remote dependencies) 728
SIMPLE datatypes 14
simple loops 102 104—108
Simple loops, emulating REPEAT UNTIL loop 106
Simple loops, exiting 105
Simple loops, infinite loop (intentional) 106
SIMPLE_DOUBLE datatype 171 246
SIMPLE_FLOAT datatype 171 246
SIMPLE_INTEGER datatype 171 239
SMTP (Simple Mail Transfer Protocol) 892
SMTP (Simple Mail Transfer Protocol), 8BITMIME 898
SMTP (Simple Mail Transfer Protocol), UFL_SMTP 893
SMTP server, conversation with PL/SQL mail client 895
SOUNDEX function 111
Source code, displaying and searching in USER_SOURCE view 713
Source code, managing see "Code management"
Sparse collections 330
Specification (packages) 618 622
Specification (packages), example 619
Specification (packages), referencing element defined in from outside the package 632
Specification (packages), rules for construction 624
SPOOL command (SQL*Plus) 33
SQL (Structured Query Language), calling functions from 602
SQL (Structured Query Language), DML statements in 441
SQL (Structured Query Language), dynamic and static SQL 513
SQL (Structured Query Language), dynamic SQL enhancements in Oracle Database 11g 14
SQL (Structured Query Language), execution of anonymous PL/SQL block containing SQL statement 984
SQL (Structured Query Language), integration with PL/SQL xxviii 7
SQL (Structured Query Language), native dynamic SQL see "NDS"
SQL (Structured Query Language), object comparisons 1111
SQL (Structured Query Language), semantics for LOBs 421—425
SQL (Structured Query Language), semantics for LOBs, performance impact of 424
SQL (Structured Query Language), semantics for LOBs, yielding temporary LOBs 423
SQL (Structured Query Language), working with collections 382—387
SQL (Structured Query Language), working with collections, CAST pseudo-function 383
SQL (Structured Query Language), working with collections, MULTISET pseudo-function 384
SQL (Structured Query Language), working with collections, sorting collection contents 386
SQL (Structured Query Language), working with collections, TABLE pseudo-function 385
SQL Developer IDE 45
SQL injection, avoiding in dynamic SQL and PL/SQL 540—542
SQL injection, preventing by using DBMS_ASSERT 1016
SQL injection, privilege escalation and 995
SQL Navigator IDE 45
SQL statements, as loops 122
SQL statements, calling deterministic functions within 615
SQL statements, qualifying references to variables and columns in 59
SQL%BULK_EXCEPTIONS attribute 832 833
SQL%BULK_ROWCOUNT attribute 832
SQL%FOUND attribute 444 476 832
SQL%ISOPEN attribute 476 832
SQL%NOTFOUND attribute 476 832
SQL%ROWCOUNT attribute 445 476 832
SQL*Plus 25—38 983
SQL*Plus User's Guide and Reference 31
SQL*Plus, benefits and limitations of 37
SQL*Plus, creating stored programs 38
SQL*Plus, current directory 31
SQL*Plus, editing statements 34
SQL*Plus, error handling 36
SQL*Plus, executing stored programs 41
SQL*Plus, exiting 34
SQL*Plus, loading custom environment automatically on startup 35
SQL*Plus, problems with & (ampersand) in PLSQL code 196
SQL*Plus, running a PL/SQL program 28
SQL*Plus, running a script 30
SQL*Plus, running a SQL statement 28
SQL*Plus, saving output to file 33
SQL*Plus, setting your preferences 32
SQL*Plus, showing stored programs 42
SQL*Plus, starting up 26
SQL*Plus, starting up, pseudo-GUI version 27
SQL*Plus, versions 25
SQLCODE function 129 140
SQLCODE function, combining with WHEN OTHERS clause 151
SQLERRM function 140
SQLERRM function, useful applications of 143
SQLPATH environment variable 30
SSL-encrypted web page, retrieving via HTTPS 907
Standard package 987
STANDARD package, compile-time warning about 742
STANDARD package, core features of PL/SQL language and dependencies 725
STANDARD package, defining PL/SQL environment 988
STANDARD package, identifiers from 68
STANDARD package, important points about 989
STANDARD package, predefined datatypes in 169
STANDARD package, predefined exceptions in 128
START command (SQLTlus) 30
STARTUP triggers 683 685
Statement sharing 1013
Statement-level triggers 653
statements 81 see "Sequential "SQL
Statements, PL/SQL, termination with semicolon (;) 74
Static polymorphism 596
Static SQL 465 513
Static typing 170
Stepwise refinement in application design 20
Stepwise refinement methodologies 592
Store table 330
| Streaming functions 512
Streaming functions, parallel pipelined functions, performance and 852
Streaming table functions 605
Streaming table functions, creating 608—611
string literals 71
String-indexed collections 365—370
String-indexed collections, emulating primary keys and unique indexes 369
String-indexed collections, other examples of 370
String-indexed collections, performance 369
String-indexed collections, simplifying algorithmic logic with 366
strings 191—230
Strings, CHAR datatype 193
strings, concatenating 198
Strings, converting datetimes to 281
Strings, converting numbers to 251—256
Strings, converting time zones to 290
Strings, converting to and from numbers 256
Strings, converting to datetimes 279
Strings, converting to intervals 294
Strings, datatypes, listed 191
Strings, dealing with case 199
Strings, empty strings 218
Strings, mixing CHAR and VARCHAR2 values 219—222
Strings, nonprintable characters 197
Strings, null and zero-length 71
strings, padding 204
Strings, quick reference for string functions 222—230
Strings, searching, extracting, and replacing, traditional 202
Strings, searching, extracting, and replacing, using regular expressions 207—218
Strings, sort order, globalization and 1049—1054
Strings, specifying string constants 195
Strings, subtypes 194
strings, trimming 206
Strings, VARCHAR2 datatype 192
Strong type 499
Sub-blocks 57
Subprograms, automatic inlining in Oracle Database 11g 15
Subprograms, execution profile of code 16
Subprograms, overloading 600
SUBSTR function 202 227 1044
SUBSTR function, negative string positioning 204
Subtypes, creating for object type 1078
Subtypes, numeric 246
Subtypes, programmer-defined 182
Subtypes, string 194
Subviews 1121
Supertype methods, invoking 16 1084
Suspendable/resumable statements 699
Suspended statements 652
symmetric encryption 923
Synchronization with database columns 180
Synonyms for stored programs 43
SYS.STANDARD package, numeric functions in 262
SYSDATE function 272 301
system exceptions 126
System exceptions, named, listing of predefined exceptions 132
System Global Area (SGA) 362 782
System Global Area (SGA), data caching in 799
System-generated object identifiers 1088
SYSTIMESTAMP function 272
SYSTIMESTAMP function, precision of timestamps returned 273
SYS_REFCURSOR datatype 173 499 1108
Table functions 386 605—615 839 see
Table functions, calling in a FROM clause 605
Table functions, creating pipelined function 611
Table functions, creating streaming function 608—611
Table functions, enabling for parallel execution 613
Table functions, passing results with a cursor variable 607
TABLE operator 605
TABLE pseudo-function 385
Table-based records, declaring 314
Tables, anchoring to 179
Tables, locking 454
TCP sockets 914
TDE (Transparent Data Encryption) 417 942
Temporary LOBs 417—421
Temporary LOBs, creating 418
Temporary LOBs, freeing 419
Temporary LOBs, managing 420
Temporary LOBs, yielded by SQL semantics for LOBs 423
Testing PL/SQL programs 746—756
Testing PL/SQL programs, automated testing options 752
Testing PL/SQL programs, general advice for 751
Testing PL/SQL programs, reasons for inadequate testing 747
Testing PL/SQL programs, typically bad approach to testing 748
Testing PL/SQL programs, typically bad approach to testing, key drawbacks of 750
Testing PL/SQL programs, using Quest Code Tester for Oracle 755
Testing PL/SQL programs, using utPLSQL 753—755
Testing, planning and developing tests 20
text 408 see
Text, checking dynamic text for dangerous content 542
TEXT_SEARCH_FUNC function 1055
THEN keyword 82
THEN keyword, requirement after ELSIF clause 86
Three-valued logic 82
time zones 268
Time zones, converting to character strings 290
Time zones, region names and time zone abbreviations 286
Time zones, session and database 272
Time zones, working with 284
Timeout values, DBMS_RESUMABLE package functions for 703
TIMESTAMP datatypes 172 268 1059
TIMESTAMP datatypes, arithmetic with intervals 300
TIMESTAMP datatypes, as inputs for datetime functions 308
TIMESTAMP datatypes, caution using DATE with 271
TIMESTAMP datatypes, considerations when choosing 271
TIMESTAMP datatypes, conversions between 273
TIMESTAMP datatypes, conversions using CAST function 298
TIMESTAMP datatypes, converting strings to 279
TIMESTAMP datatypes, converting to strings 281
TIMESTAMP datatypes, date formats and 283
TIMESTAMP datatypes, mixing with DATEs in datetime arithmetic 304
Timestamp literals 291
Timestamp mode (remote dependencies) 728
TIMESTAMP WITH LOCAL TIME ZONE datatype 268
TIMESTAMP WITH LOCAL TIME ZONE datatype, considerations when choosing 271
TIMESTAMP WITH TIME ZONE datatype 268
TIMESTAMP WITH TIME ZONE datatype, considerations when choosing 271
TIMESTAMP WITH TIME ZONE datatype, time zone information in 290
Toad IDE 24 45
TOO_MANY_ROWS exception 156
TOO_MANY_ROWS exception, raised by implicit cursor SELECT statement 473
Top-down design 20 592
TO_CHAR function 228 251—256
TO_CHAR function, converting datetime values to strings 281
TO_CHAR function, dealing with spaces 255
TO_CHAR function, examples of use for date conversions 282
TO_CHAR function, interval format masks and 295
TO_CHAR function, passing NLS settings to 256
TO_CHAR function, rounding when converting 254
TO_CHAR function, V format element 253
TO_DATE function 279
TO_DSINTERVAL function 294
TO_MULTI_BYTE function 228
TO_NCHAR function 228
TO_NUMBER function 247—251
TO_NUMBER function, passing NLS settings to 250
TO_NUMBER function, using with format model 249
TO_NUMBER function, using with no format 248
TO_TIMESTAMP function 279
TO_TIMESTAMP_TZ function 279
TO_YMINTERVAL function 294
tracing program execution 756—766
Tracing program execution, using DBMS_APPLICATION_INFO package 759
Tracing program execution, using DBMS_TRACE package 763—766
Tracing program execution, using Quest Error Manager (QEM) 761
Transactions 439 450—461
Transactions, autonomous 454—461
Transactions, autonomous, building autonomous logging mechanism 459
Transactions, autonomous, defining 455
|
|
|
О проекте