Index
A
- ACID (Atomicity, Consistency, Isolation, and Durability) / Internal LOB
- ADD_TRANSFORM function / DBMS_METADATA data types and subprograms
- advanced features, SecureFiles
- enabling / Enabling advanced features in SecureFiles, Compression, Encryption
- deduplication / Deduplication
- compression / Compression
- encryption / Encryption
- ALTER SESSION command / Securing and managing BFILEs
- ALTER SYSTEM command / Encryption
- ALTER [SYSTEM | SESSION] command / Configuring the database for the server result cache
- ALTER [SYSTEM | SESSON] command / PLSQL_OPTIMIZE_LEVEL—the Oracle initialization parameter
- AMM / Server-side result cache
- ANALYZE function / Oracle hierarchical profiler—the DBMS_HPROF package
- AND logical operator
- using, for conditional control statements rephrasing / Conditions with an AND logical operator
- APPEND procedure / DBMS_LOB subprograms
- architectural enhancements, SecureFiles
- WGC / Architectural enhancements in SecureFiles
- transformation management / Architectural enhancements in SecureFiles
- CHUNK size / Architectural enhancements in SecureFiles
- inode and space management / Architectural enhancements in SecureFiles
- prefetching / Architectural enhancements in SecureFiles
- high water mark contention / Architectural enhancements in SecureFiles
- architecture, external routines
- extproc process / Architecture of external routines
- components / Architecture of external routines
- Shared library of external routine / Architecture of external routines
- ASSM / Architectural enhancements in SecureFiles
- associative arrays
- about / Categorization, Associative arrays
- structure / Associative arrays
- data type / Associative arrays
- PL/SQL scalar data type / Associative arrays
- Inferred data / Associative arrays
- User-defined type / Associative arrays
- AUTHID CURRENT_USER option / Invoker's and definer's rights
- automatic result cache / Configuring the database for the server result cache, Automatic result cache
B
- %BULK_EXCEPTIONS / Cursor attributes
- %BULK_EXCEPTIONS attribute / Using SAVE_EXCEPTIONS
- %BULK_ROWCOUNT / Cursor attributes
- BasicFiles
- migrating, to SecureFiles / Migration from BasicFiles to SecureFiles
- BasicFiles to SecureFiles migration
- Online Redefinition method / Migration from BasicFiles to SecureFiles, Online Redefinition method
- Partition method / Migration from BasicFiles to SecureFiles
- BFILE / BFILE
- BFILE, DBMS_LOB data types / DBMS_LOB data types
- BFILENAME function / Securing and managing BFILEs
- BLOB / BLOB or CLOB!
- BLOB, DBMS_LOB data types / DBMS_LOB data types
- bulk binding
- implementing / Using bulk binding
- using / Using bulk binding
- SAVE_EXCEPTIONS, using / Using SAVE_EXCEPTIONS
- BULK COLLECT / Using bulk binding
- facts / Using bulk binding
C
- cache / Managing temporary LOBs
- about / Introduction to result cache
- cache grid / OCI client results cache
- cache group / OCI client results cache
- callback / Architecture of external routines
- callout / Architecture of external routines
- call specification / Executing C program through external procedure—development steps
- CLOB / BLOB or CLOB!
- CLOB, DBMS_LOB data types / DBMS_LOB data types
- CLOSE procedure / DBMS_LOB subprograms
- code testing, for SQL injection flaws
- test strategy / Test strategy
- code, reviewing / Reviewing the code
- static code analysis / Static code analysis
- Fuzz testing / Fuzz tools
- test case, generating / Generating test cases
- coding information
- tracking / Track coding information, [DBA | ALL | USER]_ARGUMENTS, [DBA | ALL | USER]_OBJECTS, [DBA | ALL | USER]_SOURCE, [DBA | ALL | USER]_PROCEDURES, [DBA | ALL | USER]_DEPENDENCIES
- dictionary views / Track coding information
- [DBA | ALL | USER]_ARGUMENTS / [DBA | ALL | USER]_ARGUMENTS
- [DBA | ALL | USER]_OBJECTS / [DBA | ALL | USER]_OBJECTS
- [DBA | ALL | USER]_SOURCE / [DBA | ALL | USER]_SOURCE
- [DBA | ALL | USER]_PROCEDURES / [DBA | ALL | USER]_PROCEDURES
- [DBA | ALL | USER]_DEPENDENCIES / [DBA | ALL | USER]_DEPENDENCIES
- finding, SQL developer used / Using SQL Developer to find coding information, The DBMS_DESCRIBE package, DBMS_UTILITY.FORMAT_CALL_STACK, Tracking propagating exceptions in PL/SQL code
- collection
- overview / Collections—an overview
- collection type structure / Collections—an overview
- non-persistent category / Categorization
- persistent category / Categorization
- categorizing / Categorization
- type, selecting / Selecting an appropriate collection type
- associative arrays, using / Selecting an appropriate collection type
- nested tables, using / Selecting an appropriate collection type
- varrays, using / Selecting an appropriate collection type
- about / Collections—a comparative study
- characteristics / Common characteristics of collection types
- initializing / Collection initialization
- collection elements
- manipulating / Manipulating collection elements
- collection methods, PL/SQL
- about / PL/SQL collection methods
- EXISTS function / EXISTS
- COUNT function / COUNT
- LIMIT function / LIMIT
- Last function / FIRST and LAST
- FIRST function / FIRST and LAST
- NEXT function / PRIOR and NEXT
- PRIOR function / PRIOR and NEXT
- EXTEND function / EXTEND
- TRIM function / TRIM
- DELETE function / DELETE
- COLUMN_VALUE attribute / Additional features of a nested table
- COMPARE function / DBMS_LOB subprograms
- compilation mode
- choosing / Selecting the appropriate compilation mode
- interpreted compilation mode, choosing / When to choose interpreted compilation mode?
- native compilation mode, choosing / When to choose native compilation mode?
- setting / Setting the compilation mode
- setting, at database level / Setting the compilation mode
- setting, at session level / Setting the compilation mode
- settings, querying / Querying the compilation settings
- compression feature / Compression
- COMPRESS keyword / Compression
- conditional control statements
- rephrasing / Rephrasing the conditional control statements
- rephrasing, OR logical operator used / Conditions with an OR logical operator
- rephrasing, AND logical operator used / Conditions with an AND logical operator
- CONNECT_DATA parameter / LISTENER.ora, Executing C program through external procedure—development steps
- CONSTRAINTS parameter / The DBMS_METADATA transformation parameters and filters
- CONSTRAINTS_AS_ALTER parameter / The DBMS_METADATA transformation parameters and filters
- context area / Cursors—an overview, Understanding cursor structures
- CONVERTTOBLOB procedure / DBMS_LOB subprograms
- CONVERTTOCLOB procedure / DBMS_LOB subprograms
- COPY procedure / DBMS_LOB subprograms
- COUNT function / COUNT
- CREATETEMPORARY procedure / DBMS_LOB subprograms
- cross method
- package for Java class method, creating / Creating packages for Java class methods
- Ctrl + Enter (F9) / Calling a SQL script from SQL Developer
- cursor attributes
- %ROWCOUNT / Cursor attributes, Cursor attributes
- %ISOPEN / Cursor attributes, Cursor attributes
- %FOUND / Cursor attributes, Cursor attributes
- %NOTFOUND / Cursor attributes, Cursor attributes
- about / Cursor attributes
- cursor design
- considerations / Cursor design considerations
- cursor variables, using / Cursor design considerations
- cursor execution cycle
- about / Cursor execution cycle
- cursor execution cycle, stages
- OPEN / Cursor execution cycle
- PARSE / Cursor execution cycle
- BIND / Cursor execution cycle
- EXECUTE / Cursor execution cycle
- FETCH / Cursor execution cycle
- CLOSE / Cursor execution cycle
- cursor expressions / Understanding cursor structures
- cursors
- overview / Cursors—an overview
- execution cycle / Cursor execution cycle
- cursor attributes / Cursor attributes
- FOR loop / Cursor FOR loop
- cursor structures
- about / Understanding cursor structures
- implicit cursors / Understanding cursor structures
- explicit cursors / Understanding cursor structures
- cursor variables / Understanding cursor structures
- cursor expressions / Understanding cursor structures
- Dynamic SQL / Understanding cursor structures
- cursor execution cycle / Cursor execution cycle
- cursor design considerations / Cursor design considerations
- cursor design, guidelines / Cursor design—guidelines
- cursor variables / Understanding cursor structures
- about / Cursor variables
- ref cursor, types / Ref cursor types—strong and weak
- processing / Processing a cursor variable
- as arguments / Cursor variables as arguments
- restrictions / Cursor variables—restrictions
D
- database configuration, for server-side result cache
- RESULT_CACHE_MODE parameter / Configuring the database for the server result cache
- RESULT_CACHE_MAX_SIZE parameter / Configuring the database for the server result cache
- RESULT_CACHE_REMOTE_EXPIRATION parameter / Configuring the database for the server result cache
- database dependency
- about / Managing database dependencies
- direct / Managing database dependencies
- indirect / Managing database dependencies
- indirect dependency, displaying / Displaying the direct and indirect dependencies
- direct dependency, displaying / Displaying the direct and indirect dependencies
- metadata / Dependency metadata
- issues / Dependency issues and enhancements
- enhancement / Dependency issues and enhancements
- data definitions (DDL) / Salient features of VPD
- data type / Subtypes
- DBMS_ASSERT package
- about / The DBMS_ASSERT package
- ENQUOTE_LITERAL function / The DBMS_ASSERT package
- ENQUOTE_NAME function / The DBMS_ASSERT package
- NOOP functions / The DBMS_ASSERT package
- QUALIFIED_SQL_NAME function / The DBMS_ASSERT package
- SCHEMA_NAME function / The DBMS_ASSERT package
- SIMPLE_SQL_NAME function / The DBMS_ASSERT package
- SQL_OBJECT_NAME function / The DBMS_ASSERT package
- identifier, formatting / Identifier formatting and verification process
- identifier contexts / Identifier formatting and verification process
- usage guidelines / DBMS_ASSERT—usage guidelines
- limitations / DBMS_ASSERT—limitations
- DBMS_ASSERT validation
- best practices / DBMS_ASSERT—usage guidelines
- DBMS_DESCRIBE package
- about / The DBMS_DESCRIBE package
- DBMS_HPROF package
- using / Oracle hierarchical profiler—the DBMS_HPROF package
- subprograms / Oracle hierarchical profiler—the DBMS_HPROF package
- DBMS_LOB data types
- BLOB / DBMS_LOB data types
- RAW / DBMS_LOB data types
- CLOB / DBMS_LOB data types
- VARCHAR2 / DBMS_LOB data types
- INTEGER / DBMS_LOB data types
- BFILE / DBMS_LOB data types
- DBMS_LOB package
- overview / The DBMS_LOB package—overview
- security model / Security model
- DBMS_LOB constants / DBMS_LOB constants
- DBMS_LOB data types / DBMS_LOB data types
- DBMS_LOB subprograms / DBMS_LOB subprograms
- rules, for internal LOBs / Internal LOBs
- rules, for BFILEs / BFILEs
- DBMS_LOB subprograms
- APPEND procedure / DBMS_LOB subprograms
- CLOSE procedure / DBMS_LOB subprograms
- COMPARE function / DBMS_LOB subprograms
- CONVERTTOBLOB procedure / DBMS_LOB subprograms
- CONVERTTOCLOB procedure / DBMS_LOB subprograms
- COPY procedure / DBMS_LOB subprograms
- CREATETEMPORARY procedure / DBMS_LOB subprograms
- ERASE procedure / DBMS_LOB subprograms
- FILECLOSE procedure / DBMS_LOB subprograms
- FILECLOSEALL procedure / DBMS_LOB subprograms
- FILEEXISTS function / DBMS_LOB subprograms
- FILEGETNAME procedure / DBMS_LOB subprograms
- FILEISOPEN function / DBMS_LOB subprograms
- FILEOPEN procedure / DBMS_LOB subprograms
- FRAGMENT_DELETE procedure / DBMS_LOB subprograms
- FRAGMENT_INSERT procedure / DBMS_LOB subprograms
- FRAGMENT_MOVE procedure / DBMS_LOB subprograms
- FRAGMENT_REPLACE procedure / DBMS_LOB subprograms
- FREETEMPORARY procedure / DBMS_LOB subprograms
- GETCHUNKSIZE function / DBMS_LOB subprograms
- GETLENGTH function / DBMS_LOB subprograms
- GETOPTIONS function / DBMS_LOB subprograms
- GET_STORAGE_LIMIT function / DBMS_LOB subprograms
- INSTR function / DBMS_LOB subprograms
- ISOPEN functions / DBMS_LOB subprograms
- ISTEMPORARY functions / DBMS_LOB subprograms
- LOADBLOBFROMFILE procedure / DBMS_LOB subprograms
- LOADCLOBFROMFILE procedure / DBMS_LOB subprograms
- LOADFROMFILE procedure / DBMS_LOB subprograms
- OPEN procedures / DBMS_LOB subprograms
- READ procedures / DBMS_LOB subprograms
- SETOPTIONS procedures / DBMS_LOB subprograms
- SUBSTR functions / DBMS_LOB subprograms
- TRIM procedures / DBMS_LOB subprograms
- WRITE procedures / DBMS_LOB subprograms
- WRITEAPPEND procedures / DBMS_LOB subprograms
- DBMS_METADATA
- single object metadata, retrieving / Case 1—retrieve the metadata of a single object
- object dependencies on F_GET_LOC function, retrieving / Case 2—retrieve the object dependencies on the F_GET_LOC function
- system grants on ORADEV schema retrieving / Case 3—retrieve system grants on the ORADEV schema
- function type objects, retrieving in ORADEV schema / Case 4—retrieve objects of function type in the ORADEV schema
- DBMS_METADATA package
- about / The DBMS_METADATA package
- data types / DBMS_METADATA data types and subprograms
- SYS-owned object types / DBMS_METADATA data types and subprograms
- subprograms / DBMS_METADATA data types and subprograms
- parameter requirements / Parameter requirements
- transformation parameters / The DBMS_METADATA transformation parameters and filters
- transform handlers / The DBMS_METADATA transformation parameters and filters
- DBMS_RESULT_CACHE package
- about / Configuring the database for the server result cache
- public constants / The DBMS_RESULT_CACHE package
- subprograms / The DBMS_RESULT_CACHE package
- DBMS_TRACE constant
- TRACE_ALL_CALLS / DBMS_TRACE subprograms
- TRACE_ENABLED_CALLS / DBMS_TRACE subprograms
- TRACE_ALL_EXCEPTIONS / DBMS_TRACE subprograms
- TRACE_ENABLED_EXCEPTIONS / DBMS_TRACE subprograms
- TRACE_ALL_SQL / DBMS_TRACE subprograms
- TRACE_ENABLED_SQL / DBMS_TRACE subprograms
- TRACE_ALL_LINES / DBMS_TRACE subprograms
- TRACE_ENABLED_LINES / DBMS_TRACE subprograms
- TRACE_PAUSE / DBMS_TRACE subprograms
- TRACE_RESUME / DBMS_TRACE subprograms
- TRACE_STOP / DBMS_TRACE subprograms
- TRACE_LIMIT / DBMS_TRACE subprograms
- TRACE_MINOR_VERSION / DBMS_TRACE subprograms
- TRACE_MAJOR_VERSION / DBMS_TRACE subprograms
- NO_TRACE_ADMINISTRATIVE / DBMS_TRACE subprograms
- NO_TRACE_HANDLED_EXCEPTIONS / DBMS_TRACE subprograms
- DBMS_TRACE package
- about / The DBMS_TRACE package
- installing / Installing DBMS_TRACE
- subprograms / DBMS_TRACE subprograms, Practice exercise
- DBMS_TRACE subprogram
- CLEAR_PLSQL_TRACE procedure / DBMS_TRACE subprograms
- GET_PLSQL_TRACE_LEVEL function / DBMS_TRACE subprograms
- GET_PLSQL_TRACE_RUNNUMBER function / DBMS_TRACE subprograms
- PLSQL_TRACE_VERSION procedure / DBMS_TRACE subprograms
- SET_PLSQL_TRACE procedure / DBMS_TRACE subprograms
- COMMENT_PLSQL_TRACE procedure / DBMS_TRACE subprograms
- INTERNAL_VERSION_CHECK function / DBMS_TRACE subprograms
- LIMIT_PLSQL_TRACE procedure / DBMS_TRACE subprograms
- PAUSE_PLSQL_TRACE procedure / DBMS_TRACE subprograms
- RESUME_PLSQL_TRACE procedure / DBMS_TRACE subprograms
- db_securefile parameter / Working with SecureFiles
- Debug option / Debugging the PL/SQL code
- DEDUPLICATE keyword / Deduplication
- deduplication feature / Deduplication
- DEFAULT parameter / The DBMS_METADATA transformation parameters and filters
- DELETE function / DELETE
- dense collection / Nested tables
- development steps, VPD implementation
- application context, creating / VPD implementation—outline and components
- context key, creating / VPD implementation—outline and components
- context key, setting / VPD implementation—outline and components
- Policy function, creating / VPD implementation—outline and components
- directories, LOB data types / Directories
- DIRECTORY parameter / Encryption
- DML operations, performing on nested table
- data, inserting / Inserting a nested table instance
- column, selecting / Selecting a nested table column
- data, updating / Updating the nested table instance
- DML operations, performing on varray
- data, inserting / Inserting a varray collection type instance
- column, selecting / Selecting a varray column
- varray instance, updating / Updating the varray instance
- DROP command / Varray
- duration / Managing temporary LOBs
- Dynamic SQL / Understanding cursor structures
E
- EMPTY_BLOB() function / Managing internal LOBs, Inserting data into a LOB column
- EMPTY_CLOB() function / Managing internal LOBs
- encryption algorithms, SecureFiles
- 3DES168 / Encryption
- AES128 / Encryption
- AES192 / Encryption
- AES256 / Encryption
- ENCRYPT keyword / Encryption
- ENQUOTE_LITERAL function / The DBMS_ASSERT package
- ENQUOTE_NAME function / The DBMS_ASSERT package
- ERASE procedure / DBMS_LOB subprograms
- error_number parameter / The RAISE_APPLICATION_ERROR procedure
- ETL / Oracle hierarchical profiler—the DBMS_HPROF package
- exception
- about / Exception handling in PL/SQL
- system-defined exception / Exception handling in PL/SQL, System-defined exceptions
- user-defined exceptions / User-defined exceptions
- exception handling, in PL/SQL
- about / Exception handling in PL/SQL
- system-defined exceptions / System-defined exceptions
- user-defined exceptions / User-defined exceptions
- exception propagation / Exception propagation
- EXCEPTION variable / The RAISE_APPLICATION_ERROR procedure
- EXISTS function / EXISTS
- explicit cursors / Cursors—an overview, Understanding cursor structures
- about / Explicit cursors
- EXTEND function / EXTEND
- EXTEND method / EXTEND
- external C programs
- executing, from PL/SQL / Executing external C programs from PL/SQL
- executing, through C program / Executing C program through external procedure—development steps
- external LOB / External LOB
- external procedures, benefits / Benefits of external procedures
- Integration of strengths / Benefits of external procedures
- Reusability of client logic / Benefits of external procedures
- logical extensibility / Benefits of external procedures
- enhanced performance / Benefits of external procedures
- external program, publishing / Executing C program through external procedure—development steps
- external routines
- about / Understanding external routines
- architecture / Architecture of external routines
- diagrammatic representation / Architecture of external routines
- extproc process / Architecture of external routines
- Oracle Net Configuration / Oracle Net Configuration
- external procedures, benefits / Benefits of external procedures
F
- %FOUND / Cursor attributes, Cursor attributes
- FGAC / Overview
- overview / Fine Grained Access Control
- about / Fine Grained Access Control
- working / How FGAC or VPD works?
- FGD / Dependency issues and enhancements
- FILECLOSEALL procedure / DBMS_LOB subprograms
- FILECLOSE procedure / DBMS_LOB subprograms
- FILEEXISTS function / DBMS_LOB subprograms
- FILEGETNAME procedure / DBMS_LOB subprograms
- FILEISOPEN function / DBMS_LOB subprograms
- FILEOPEN procedure / DBMS_LOB subprograms
- FIRST function / FIRST and LAST
- FORALL function / Tuning PL/SQL code
- FORALL loop / Using bulk binding
- FORCE parameter / The DBMS_METADATA transformation parameters and filters
- FORMAT_CALL_STACK function / DBMS_UTILITY.FORMAT_CALL_STACK
- forward declaration / Modularizing the PL/SQL code
- FRAGMENT_DELETE procedure / DBMS_LOB subprograms
- FRAGMENT_INSERT procedure / DBMS_LOB subprograms
- FRAGMENT_MOVE procedure / DBMS_LOB subprograms
- FRAGMENT_REPLACE procedure / DBMS_LOB subprograms
- FREETEMPORARY procedure / DBMS_LOB subprograms
- frst-order attack / Types of SQL injection attacks
- functions
- about / Functions
- characteristics / Functions
- syntax / Functions
- execution methods / Function—execution methods
- SQL expressions calling functions, rules / Restrictions on calling functions from SQL expressions
- standalone user-defined function / Restrictions on calling functions from SQL expressions
- fuzz testing / Fuzz tools
- F_COMPUTE function / The loadjava utility—an illustration
- F_COMPUTE_SUM function / The loadjava utility—an illustration
- F_COMP_INT function / Compiling a program unit for a native or interpreted compilation
- F_GET_DOUBLE function / Restrictions on calling functions from SQL expressions
- F_GET_FUN_DDL function / Case 4—retrieve objects of function type in the ORADEV schema
- F_GET_LOC function / Demonstrating the profiling of a PL/SQL program
- F_GET_NAME function / Track coding information
- F_GET_SAL function / The RESULT_CACHE clause
- F_PRINT_NAME function / [DBA | ALL | USER]_ARGUMENTS
G
- GETCHUNKSIZE function / DBMS_LOB subprograms
- GETLENGTH function / DBMS_LOB subprograms
- GETOPTIONS function / DBMS_LOB subprograms
- GET_QUERY function / DBMS_METADATA data types and subprograms
- GET_STORAGE_LIMIT function / DBMS_LOB subprograms
- GET_[XML | DDL | CLOB] functions / DBMS_METADATA data types and subprograms
- GRANT command / Directories
- GUI / SQL Developer
H
- hierarchical profiler
- efficiencies / Oracle hierarchical profiler—the DBMS_HPROF package
- DBMS_HPROF package, using / Oracle hierarchical profiler—the DBMS_HPROF package
- Data collector / Oracle hierarchical profiler—the DBMS_HPROF package
- Analyzer / Oracle hierarchical profiler—the DBMS_HPROF package
- profiler information, viewing / View profiler information
- PL/SQL program profiling demonstration / Demonstrating the profiling of a PL/SQL program
- hierarchical profiling / Oracle hierarchical profiler—the DBMS_HPROF package
I
- %ISOPEN / Cursor attributes, Cursor attributes
- identifier contexts, DBMS_ASSERT package
- unquoted identifier / Identifier formatting and verification process
- quoted identifier / Identifier formatting and verification process
- literal / Identifier formatting and verification process
- basic / Identifier formatting and verification process
- simple / Identifier formatting and verification process
- qualified / Identifier formatting and verification process
- identifiers
- about / Determining identifier types and usages
- activities identification, PL/Scope tool used / Determining identifier types and usages
- IF THEN ELSE expression / Rephrasing the conditional control statements
- IMBD / OCI client results cache
- implicit cursors / Cursors—an overview, Understanding cursor structures
- about / Understanding cursor structures, Implicit cursors
- INHERIT parameter / The DBMS_METADATA transformation parameters and filters
- INSTR function / DBMS_LOB subprograms
- INTEGER, DBMS_LOB data types / DBMS_LOB data types
- internal LOB / Internal LOB
- BLOB type / BLOB or CLOB!
- CLOB type / BLOB or CLOB!
- NCLOB type / BLOB or CLOB!
- interpreted compilation / Native and interpreted compilation techniques
- program unit, comparing / Compiling a program unit for a native or interpreted compilation
- intra unit inlining
- enabling / Enabling intra unit inlining
- ISOPEN functions / DBMS_LOB subprograms
- ISTEMPORARY functions / DBMS_LOB subprograms
J
- Java pool / Executing Java programs from PL/SQL
- Java programs
- executing, from PL/SQL / Executing Java programs from PL/SQL
- Java class method, calling / Calling a Java class method from PL/SQL
- Java class, uploading into database / Uploading a Java class into the database—development steps
- package for Java class method, creating / Creating packages for Java class methods
- Java programs, executing from PL/SQL
- about / Executing Java programs from PL/SQL
- Java class method, calling / Calling a Java class method from PL/SQL
- Java class, uploading into database / Uploading a Java class into the database—development steps
- loadjava utility / The loadjava utility—an illustration
- packages, creating / Creating packages for Java class methods
- JVM / Executing Java programs from PL/SQL
L
- LAST function / FIRST and LAST
- LENGTH function / Accessing LOBs
- LIMIT function / LIMIT
- LIMIT method / LIMIT
- LISTENER.ora / LISTENER.ora
- Literal / Identifier formatting and verification process
- LOADBLOBFROMFILE procedure / DBMS_LOB subprograms
- LOADCLOBFROMFILE procedure / DBMS_LOB subprograms
- LOADFROMFILE procedure / DBMS_LOB subprograms
- loadjava utility / The loadjava utility—an illustration
- LOB
- column states / LOB column states
- row, locking / Locking a row containing LOB
- opening / Opening and closing LOBs
- closing / Opening and closing LOBs
- restrictions / LOB restrictions
- migrating, from LONG data types / Migrating from LONG to LOB
- LOB column
- data, inserting into / Inserting data into a LOB column
- accessing / Accessing LOBs
- LOB column states
- NULL / LOB column states
- Empty / LOB column states
- Populated / LOB column states
- LOB data
- selecting / Selecting LOB data
- modifying / Modifying the LOB data
- deleting / Delete LOB data
- LOB data type
- classification chart / Introduction to the LOB data types
- internal LOB / Internal LOB
- external LOB / External LOB
- BFILE / BFILE
- temporary LOBs / Temporary LOBs
- populating, external file used / Populating a LOB data type using an external file
- LOB data type columns
- initializing / Initializing LOB data type columns
- LOB data types
- about / Introduction to the LOB data types, Understanding the LOB data types
- LOB locators / LOB value and LOB locators
- LOB value / LOB value and LOB locators
- creating / Creating LOB data types
- directories / Directories
- columns, creating in table / Creating LOB data type columns in a table
- creating, syntax / Creating LOB data type columns in a table
- managing / Managing LOB data types, Securing and managing BFILEs, The DBMS_LOB package—overview
- internal LOBs, managing / Managing internal LOBs
- BFILEs, managing / Securing and managing BFILEs
- BFILEs, securing / Securing and managing BFILEs
- DBMS_LOB package / The DBMS_LOB package—overview
- lob_loc / Managing temporary LOBs
- LONG data types
- limitations / Introduction to the LOB data types
- migrating to LOB / Migrating from LONG to LOB
- LONG RAW data types
- limitations / Introduction to the LOB data types
M
- machine code (bytecode) / Native and interpreted compilation techniques
- manual result cache / Configuring the database for the server result cache, Manual result cache
N
- %NOTFOUND / Cursor attributes, Cursor attributes
- native compilation
- about / Native and interpreted compilation techniques
- program unit, comparing / Compiling a program unit for a native or interpreted compilation
- NCOMP / Compiling the database for PL/SQL native compilation (NCOMP)
- nested table
- about / Categorization, Nested tables
- creating, as database object / Nested table collection type as the database object
- DML operations / DML operations on nested table columns
- in PL/SQL / A nested table collection type in PL/SQL
- features / Additional features of a nested table
- versus associative arrays / Nested table versus associative arrays
- versus varray / Nested table versus varrays
- nested tables
- using / Selecting an appropriate collection type
- NOCACHE mode / SecureFile LOB features
- non-persistent collection
- associative array / Categorization
- NOOP functions / The DBMS_ASSERT package
- NOT NULL constraint / Understanding the NOT NULL constraint
O
- OCI client results cache / OCI client results cache
- OID parameter / The DBMS_METADATA transformation parameters and filters
- OLTP / Architectural enhancements in SecureFiles
- Online Redefinition method
- about / Online Redefinition method
- pre-requisites / Online Redefinition method
- LOB columns, migrating / Online Redefinition method
- OPEN function / DBMS_METADATA data types and subprograms
- OPEN procedures / DBMS_LOB subprograms
- OPENW function / DBMS_METADATA data types and subprograms
- Oracle-supplied packages
- reviewing / Reviewing Oracle-supplied packages
- packages / Reviewing Oracle-supplied packages
- DBMS_ALERT / Reviewing Oracle-supplied packages
- DBMS_LOCK / Reviewing Oracle-supplied packages
- DBMS_SESSION / Reviewing Oracle-supplied packages
- DBMS_OUTPUT / Reviewing Oracle-supplied packages
- DBMS_HTTP / Reviewing Oracle-supplied packages
- UTL_FILE / Reviewing Oracle-supplied packages
- UTL_MAIL / Reviewing Oracle-supplied packages
- DBMS_SCHEDULER / Reviewing Oracle-supplied packages
- packages, categorizing / Reviewing Oracle-supplied packages
- Oracle 11g / Introduction to the LOB data types
- memory infrastructure diagram / Server-side result cache
- Oracle initialization parameter
- enabling / PLSQL_OPTIMIZE_LEVEL—the Oracle initialization parameter
- Oracle initialization parameter
- PLSQL_OPTIMIZE_LEVELs / Case 1—PLSQL_OPTIMIZE_LEVEL = 0, Case 2—PLSQL_OPTIMIZE_LEVEL = 1, Case 3—PLSQL_OPTIMIZE_LEVEL = 2, Case 4—PLSQL_OPTIMIZE_LEVEL = 3
- Oracle Net Configuration
- about / Oracle Net Configuration
- TNSNAMES.ora / TNSNAMES.ora
- LISTENER.ora / LISTENER.ora
- verifying / Oracle Net Configuration verification
- ORACLR / Architecture of external routines
- OR logical operator
- using, for conditional control statements rephrasing / Conditions with an OR logical operator
- OTN / Creating a connection
P
- packages
- about / PL/SQL packages
- advantage / PL/SQL packages
- components, package specification / PL/SQL packages
- components, package body / PL/SQL packages
- creating, syntax / PL/SQL packages
- parent table
- about / Nested tables
- partition method
- about / Migration from BasicFiles to SecureFiles
- new SecureFile partition / Migration from BasicFiles to SecureFiles
- partitioned table, creating / Migration from BasicFiles to SecureFiles
- persistent collection
- nested table / Categorization
- Varray (variable-size array) / Categorization
- PGA / Cursor execution cycle
- PL/Scope tool
- about / The PL/Scope tool
- key features / The PL/Scope tool
- identifier collection / The PL/Scope identifier collection
- report / The PL/Scope report
- identifier information, capturing / Illustration
- report, objectives / Applications of the PL/Scope report
- PL/SQL / PL/SQL—the procedural aspect
- accomplishments / PL/SQL—the procedural aspect
- program / My first PL/SQL program
- exception handling / Exception handling in PL/SQL
- nested table / A nested table collection type in PL/SQL
- Varray / Varray in PL/SQL
- collection methods / PL/SQL collection methods
- external C programs, executing / Executing external C programs from PL/SQL
- external C programs, executing through external procedure / Executing C program through external procedure—development steps
- Java programs, executing / Executing Java programs from PL/SQL
- Java class method, calling / Calling a Java class method from PL/SQL
- Java class, uploading into database / Uploading a Java class into the database—development steps
- comparing, with SQL / Comparing SQL and PL/SQL
- PLS_INTEGER data type, using / Using the PLS_INTEGER data type for arithmetic operations
- PL/SQL block
- structure / My first PL/SQL program
- header / My first PL/SQL program
- declaration / My first PL/SQL program
- execution / My first PL/SQL program
- structure diagram / My first PL/SQL program
- PL/SQL code
- tuning, areas / Tuning PL/SQL code
- SQL, comparing with PL/SQL / Comparing SQL and PL/SQL
- implicit data type conversion, avoiding / Avoiding implicit data type conversion
- NOT NULL constraint / Understanding the NOT NULL constraint
- SIMPLE_INTEGER data type, using / Using a SIMPLE_INTEGER data type
- modularizing / Modularizing the PL/SQL code
- bulk binding, using / Using bulk binding
- PL/SQL code, designing
- cursor structures / Understanding cursor structures
- cursor variables / Cursor variables
- subtypes / Subtypes
- PL/SQL development environments
- SQL Developer / SQL Developer
- SQL*Plus / SQL*Plus
- PL/SQL function result cache
- limitations / Limitations of PL/SQL function result cache, Function structural restrictions
- argument and return type limitations / Argument and return type restrictions
- function structural limitations / Function structural restrictions
- PL/SQL native compilation
- database, compiling / Compiling the database for PL/SQL native compilation (NCOMP)
- PL/SQL program
- anonymous / My first PL/SQL program
- named / My first PL/SQL program
- nested / My first PL/SQL program
- plshprof utility / The plshprof utility
- PL/SQL program, profiling
- hierarchical profiling / Oracle hierarchical profiler—the DBMS_HPROF package
- PL/SQL program, tracing
- methods / Tracing the PL/SQL programs
- DBMS_TRACE package / The DBMS_TRACE package
- PLSQL_DEBUG parameter / The PLSQL_DEBUG parameter and the DEBUG option
- PL/SQL programs
- tracing / Tracing the PL/SQL programs
- profiling / Profiling the PL/SQL programs
- PL/SQL trace information
- viewing / Viewing the PL/SQL trace information
- PL/SQL tracing
- demonstrating / Demonstrating the PL/SQL tracing
- plshprof utility
- about / The plshprof utility
- sample reports / Sample reports
- PLSQL_CODE_TYPE parameter / Setting the compilation mode
- PLSQL_DEBUG parameter / The PLSQL_DEBUG parameter and the DEBUG option
- PLSQL_OPTIMIZE_LEVEL=0 / Case 1—PLSQL_OPTIMIZE_LEVEL = 0
- PLSQL_OPTIMIZE_LEVEL=1 / Case 2—PLSQL_OPTIMIZE_LEVEL = 1
- PLSQL_OPTIMIZE_LEVEL=2 / Case 3—PLSQL_OPTIMIZE_LEVEL = 2
- PLSQL_OPTIMIZE_LEVEL=3 / Case 4—PLSQL_OPTIMIZE_LEVEL = 3
- PLSQL_WARNINGS / PRAGMA INLINE
- PLSQL_WARNINGS parameter / Enabling intra unit inlining
- PLS_INTEGER data type
- using, for arithmetic operations / Using the PLS_INTEGER data type for arithmetic operations
- policy types
- STATIC / Policy function definition and implementation of row-level security
- DYNAMIC (Default) / Policy function definition and implementation of row-level security
- SHARED_STATIC / Policy function definition and implementation of row-level security
- CONTEXT_SENSITIVE / Policy function definition and implementation of row-level security
- SHARED_CONTEXT_SENSITIVE / Policy function definition and implementation of row-level security
- policy utilities
- drop / Policy utilities—refresh and drop
- refresh / Policy utilities—refresh and drop
- Pragma / User-defined exceptions
- PRAGMA EXCEPTION_INIT / User-defined exceptions
- PRAGMA INLINE / PRAGMA INLINE
- PRETTY parameter / The DBMS_METADATA transformation parameters and filters
- PRIOR function / PRIOR and NEXT
- procedure
- about / Procedures
- characteristics / Procedures
- IN parameters / Procedures
- OUT parameters / Procedures
- IN OUT parameters / Procedures
- syntax / Procedures
- executing / Executing a procedure
- Program Unit Arguments option / Using SQL Developer to find coding information
Q
- QUALIFIED_SQL_NAME function / The DBMS_ASSERT package
- Quoted identifier / Identifier formatting and verification process
R
- %ROWCOUNT / Cursor attributes, Cursor attributes
- RAISE_APPLICATION_ERROR procedure / The RAISE_APPLICATION_ERROR procedure
- RAW, DBMS_LOB data types / DBMS_LOB data types
- READ procedures / DBMS_LOB subprograms
- real native compilation
- about / Real native compilation
- accomplishments / Real native compilation
- ref cursor
- about / Ref cursor types—strong and weak
- weak type / Ref cursor types—strong and weak
- strong type / Ref cursor types—strong and weak
- SYS_REFCURSOR / SYS_REFCURSOR
- REF_CONSTRAINTS parameter / The DBMS_METADATA transformation parameters and filters
- Remote-Ops (RO) / TNSNAMES.ora
- result cache / Server-side result cache
- about / Introduction to result cache
- server-side result cache / Server-side result cache
- OCI client / OCI client results cache
- implementing, in SQL / Implementing the result cache in SQL
- limitation / Limitation of SQL result cache
- implementing, in PL/SQL / Implementing result cache in PL/SQL
- result cache implementation, in PL/SQL
- about / Implementing result cache in PL/SQL
- RESULT_CACHE clause / The RESULT_CACHE clause
- cross-session availability / Cross-session availability of cached results
- invalidating / Invalidation of PL/SQL result cache
- limitations / Limitations of PL/SQL function result cache
- result cache implementation, in SQL
- manual result cache / Manual result cache
- automatic result cache / Automatic result cache
- result cache metadata / Result cache metadata
- SQL result cache, invalidating / Invalidation of SQL result cache
- memory report, displaying / Displaying the result cache memory report
- read consistency / Read consistency of the SQL result cache
- result cache metadata
- about / Result cache metadata
- dependent objects / Query result cache dependencies
- memory statistics / Cache memory statistics
- RESULT_CACHE_MAX_SIZE parameter / Configuring the database for the server result cache
- RESULT_CACHE_MODE parameter / Configuring the database for the server result cache, Manual result cache
- RESULT_CACHE_REMOTE_EXPIRATION parameter / Configuring the database for the server result cache
- RLS / Virtual Private Database—the alias
S
- SCHEMA_NAME function / The DBMS_ASSERT package
- second-order attack / Types of SQL injection attacks
- SecureFile performance graph / Architectural enhancements in SecureFiles
- SECUREFILE property / Online Redefinition method
- SecureFiles
- about / Introduction to SecureFiles
- feature / Introduction to SecureFiles
- architectural enhancements / SecureFile LOB—an overview
- LOB features / SecureFile LOB features
- working with / Working with SecureFiles, SecureFile metadata, Enabling advanced features in SecureFiles
- metadata / SecureFile metadata
- advanced features, enabling / Enabling advanced features in SecureFiles
- encryption algorithms / Encryption
- migrating, from BasicFiles / Migration from BasicFiles to SecureFiles
- SEGMENT_ATTRIBUTES parameter / The DBMS_METADATA transformation parameters and filters
- server-side result cache
- about / Server-side result cache
- SQL query result cache / SQL query result cache
- PL/SQL function result cache / PL/SQL function result cache
- database, configuring / Configuring the database for the server result cache
- DBMS_RESULT_CACHE package / The DBMS_RESULT_CACHE package
- SERVEROUTPUT parameter / My first PL/SQL program
- session cursors / Cursor execution cycle
- SETOPTIONS procedures / DBMS_LOB subprograms
- SGA / Collections—an overview, Application context
- SIMPLE_INTEGER data type
- using / Using a SIMPLE_INTEGER data type
- SIMPLE_SQL_NAME function / The DBMS_ASSERT package
- SIZE_BYTE_KEYWORD parameter / The DBMS_METADATA transformation parameters and filters
- SQL
- comparing, with PL/SQL / Comparing SQL and PL/SQL
- SQL*Plus
- about / SQL*Plus
- evolution cycle / SQL*Plus
- SQL statement, executing / Executing a SQL statement in SQL*Plus
- anonymous PL/SQL block, executing / Executing an anonymous PL/SQL block
- SQL Developer
- about / SQL Developer
- accomplishments / SQL Developer
- features / SQL Developer
- Oracle SQL Developer, start page / SQL Developer
- history / SQL Developer—the history
- connection, creating / Creating a connection
- SQL Worksheet / SQL Worksheet
- SQL statement, executing / Executing a SQL statement
- SQL script, calling from / Calling a SQL script from SQL Developer
- anonymous PL/SQL block, creating / Creating and executing an anonymous PL/SQL block
- anonymous PL/SQL block, executing / Creating and executing an anonymous PL/SQL block
- PL/SQL code, debugging / Debugging the PL/SQL code
- scripts, editing / Editing and saving the scripts
- scripts, saving / Editing and saving the scripts
- SQL developer
- using, for coding information search / Using SQL Developer to find coding information, The DBMS_DESCRIBE package, DBMS_UTILITY.FORMAT_CALL_STACK, Tracking propagating exceptions in PL/SQL code
- about / Using SQL Developer to find coding information
- DBMS_DESCRIBE package / The DBMS_DESCRIBE package
- SQLERRM function / Using SAVE_EXCEPTIONS
- SQL injection
- about / SQL injection—an introduction
- overview / SQL injection—an overview
- code injection, example / SQL injection—an overview
- attack types / Types of SQL injection attacks
- attack types, first-order attack / Types of SQL injection attacks
- attack types, second-order attack / Types of SQL injection attacks
- impacts / Types of SQL injection attacks
- attacks, preventing / Preventing SQL injection attacks
- attack immunization / Immunizing SQL injection attacks
- flaws, testing / Testing the code for SQL injection flaws
- SQL injection attack immunization
- about / Immunizing SQL injection attacks
- attack surface, reducing / Reducing the attack's surface
- user privileges, controlling / Controlling user privileges
- owners right / Invoker's and definer's rights
- definers right / Invoker's and definer's rights
- dynamic SQL, avoiding / Avoiding dynamic SQL
- bind arguments / Bind arguments
- input sanitization , DBMS_ASSERT used / Sanitizing inputs using DBMS_ASSERT
- SQL injection flaws
- code, testing / Testing the code for SQL injection flaws
- SQLTERMINATOR parameter / The DBMS_METADATA transformation parameters and filters
- SQL_OBJECT_NAME function / The DBMS_ASSERT package
- START_PROFILING procedure / Oracle hierarchical profiler—the DBMS_HPROF package
- static code analysis / Static code analysis
- STOP_PROFILING procedure / Oracle hierarchical profiler—the DBMS_HPROF package
- STORAGE parameter / The DBMS_METADATA transformation parameters and filters
- subprograms, DBMS_RLS package
- ADD_POLICY / Associating a policy using the DBMS_RLS package
- DROP_POLICY / Associating a policy using the DBMS_RLS package
- REFRESH_POLICY / Associating a policy using the DBMS_RLS package
- ENABLE_POLICY / Associating a policy using the DBMS_RLS package
- CREATE_POLICY_GROUP / Associating a policy using the DBMS_RLS package
- ADD_GROUPED_POLICY / Associating a policy using the DBMS_RLS package
- ADD_POLICY_CONTEXT / Associating a policy using the DBMS_RLS package
- DELETE_POLICY_GROUP / Associating a policy using the DBMS_RLS package
- DROP_GROUPED_POLICY / Associating a policy using the DBMS_RLS package
- DROP_POLICY_CONTEXT / Associating a policy using the DBMS_RLS package
- ENABLE_GROUPED_POLICY / Associating a policy using the DBMS_RLS package
- DISABLE_GROUPED_POLICY / Associating a policy using the DBMS_RLS package
- SUBSTR functions / DBMS_LOB subprograms
- subtype
- about / Subtypes
- evolution / Subtypes
- classifying / Subtype classification
- Oracle predefined subtypes / Oracle's predefined subtypes
- user-defined subtypes / User-defined subtypes
- benefits / User-defined subtypes
- type compatibility / Type compatibility with subtypes
- Sum method
- package for Java class method, creating / Creating packages for Java class methods
- SYS.KU$_DDL / DBMS_METADATA data types and subprograms
- SYS.KU$_DDLS / DBMS_METADATA data types and subprograms
- SYS.KU$_ERRORLINE / DBMS_METADATA data types and subprograms
- SYS.KU$_ERRORLINES / DBMS_METADATA data types and subprograms
- SYS.KU$_MULTI_DDL / DBMS_METADATA data types and subprograms
- SYS.KU$_MULTI_DDLS / DBMS_METADATA data types and subprograms
- SYS.KU$_PARSED_ITEM / DBMS_METADATA data types and subprograms
- SYS.KU$_PARSED_ITEMS / DBMS_METADATA data types and subprograms
- SYS.KU$_SUBMITRESULT / DBMS_METADATA data types and subprograms
- SYS.KU$_SUBMITRESULTS / DBMS_METADATA data types and subprograms
- system-defined exception / System-defined exceptions
- system-defined exception
- list / System-defined exceptions
- SYS_CONTEXT function / Application context, Assignment 2—implementing VPD using an application context
- SYS_REFCURSOR / SYS_REFCURSOR
T
- TABLESPACE parameter / The DBMS_METADATA transformation parameters and filters
- TDE / SecureFile LOB features, Encryption
- temporary LOBs
- using / Using temporary LOBs
- operations / Temporary LOB operations
- managing / Managing temporary LOBs
- validating / Validating, creating, and freeing a temporary LOB
- creating / Validating, creating, and freeing a temporary LOB
- releasing / Validating, creating, and freeing a temporary LOB
- tkprof utility / Tracing the PL/SQL programs
- TNS / TNSNAMES.ora
- TRACE parameter / Demonstrating the profiling of a PL/SQL program
- tracing
- PL/SQL programs / Tracing the PL/SQL programs
- DBMS_APPLICATION_INFO method / Tracing the PL/SQL programs
- DBMS_TRACE method / Tracing the PL/SQL programs
- DBMS_SESSION and DBMS_MONITOR method / Tracing the PL/SQL programs
- trcsess utility / Tracing the PL/SQL programs
- TRIM function / TRIM
- TRIM procedures / DBMS_LOB subprograms
U
- UGA / Collections—an overview, Application context
- Unquoted identifier / Identifier formatting and verification process
- user-defined exceptions
- about / User-defined exceptions
- declaring, ways / User-defined exceptions
- declaring, in PL/SQL block / User-defined exceptions
- RAISE_APPLICATION_ERROR procedure / The RAISE_APPLICATION_ERROR procedure
- USING clause / Bind arguments
V
- VARCHAR2, DBMS_LOB data types / DBMS_LOB data types
- Varray
- about / Categorization, Varray
- in PL/SQL / Varray in PL/SQL
- as database collection type / Varray as a database collection type
- DML operations / DML operations on varray type columns
- versus nested table / Nested table versus varrays
- VARRAY.DELETE method / DELETE
- varrays
- using / Selecting an appropriate collection type
- VPD
- about / Overview
- RLS, working / Virtual Private Database—the alias
- working / How FGAC or VPD works?
- features / Salient features of VPD
- implementing, development steps / VPD implementation—outline and components
- policy metadata / VPD policy metadata
- VPD implementation
- development, steps / VPD implementation—outline and components
- application context / Application context
- policy function / Policy function definition and implementation of row-level security
- policy association, DBMS_RLS package used / Associating a policy using the DBMS_RLS package
- demonstrating / VPD implementation—demonstrations, Assignment 1—implementing VPD using simple security policy, Assignment 2—implementing VPD using an application context
- simple security policy, using / Assignment 1—implementing VPD using simple security policy
- application context, using / Assignment 2—implementing VPD using an application context
W
- WGC / Architectural enhancements in SecureFiles
- WRITEAPPEND procedures / DBMS_LOB subprograms
- WRITE procedures / DBMS_LOB subprograms
