Skip Headers
Oracle® Database Application Developer's Guide - Expression Filter
10
g
Release 1 (10.1)
Part Number B10821-01
Home
Book List
Index
Master Index
Feedback
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
1
Oracle Expression Filter Concepts
1.1
What Is Expression Filter?
1.1.1
Expression Filter Usage Scenarios
1.2
Introduction to Expressions
1.2.1
Defining Attribute Sets
1.2.2
Defining Expression Columns
1.2.3
Inserting, Updating, and Deleting Expressions
1.3
Applying the SQL EVALUATE Operator
1.4
Evaluation Semantics
1.5
Granting and Revoking Privileges
1.6
Error Messages
2
Indexing Expressions
2.1
Concepts of Indexing Expressions
2.2
Indexable Predicates
2.3
Index Representation
2.4
Index Processing
2.5
Predicate Table Query
2.6
Index Creation and Tuning
2.7
Index Usage
2.8
Index Storage and Maintenance
3
Expressions with XPath Predicates
3.1
Using XPath Predicates in Expressions
3.2
Indexing XPath Predicates
3.2.1
Indexable XPath Predicates
3.2.2
Index Representation
3.2.3
Index Processing
3.2.4
Index Tuning for XPath Predicates
4
Expression Filter Internal Objects
4.1
Attribute Set Object Type
4.2
Expression Validation Trigger
4.3
Expression Filter Index Objects
4.4
Expression Filter System Triggers
5
Using Expression Filter with Utilities
5.1
Bulk Loading of Expression Data
5.2
Exporting and Importing Tables, Users, and Databases
5.2.1
Exporting and Importing Tables Containing Expression Columns
5.2.2
Exporting a User Owning Attribute Sets
5.2.3
Exporting a Database Containing Attribute Sets
6
SQL Operators and Statements
EVALUATE
ALTER INDEX REBUILD
ALTER INDEX RENAME TO
CREATE INDEX
DROP INDEX
7
Object Types
EXF$ATTRIBUTE
EXF$ATTRIBUTE_LIST
EXF$INDEXOPER
EXF$TABLE_ALIAS
EXF$XPATH_TAG
EXF$XPATH_TAGS
8
Management Procedures Using the DBMS_EXPFIL Package
ADD_ELEMENTARY_ATTRIBUTE Procedure
ADD_FUNCTIONS Procedure
ASSIGN_ATTRIBUTE_SET Procedure
BUILD_EXCEPTIONS_TABLE Procedure
CLEAR_EXPRSET_STATS Procedure
COPY_ATTRIBUTE_SET Procedure
CREATE_ATTRIBUTE_SET Procedure
DEFAULT_INDEX_PARAMETERS Procedure
DEFAULT_XPINDEX_PARAMETERS Procedure
DEFRAG_INDEX Procedure
DROP_ATTRIBUTE_SET Procedure
GET_EXPRSET_STATS Procedure
GRANT_PRIVILEGE Procedure
INDEX_PARAMETERS Procedure
REVOKE_PRIVILEGE Procedure
UNASSIGN_ATTRIBUTE_SET Procedure
VALIDATE_EXPRESSIONS Procedure
XPINDEX_PARAMETERS Procedure
9
Expression Filter Views
9.1
USER_EXPFIL_ASET_FUNCTIONS View
9.2
USER_EXPFIL_ATTRIBUTES View
9.3
USER_EXPFIL_ATTRIBUTE_SETS View
9.4
USER_EXPFIL_DEF_INDEX_PARAMS View
9.5
USER_EXPFIL_EXPRESSION_SETS View
9.6
USER_EXPFIL_EXPRSET_STATS View
9.7
USER_EXPFIL_INDEX_PARAMS View
9.8
USER_EXPFIL_INDEXES View
9.9
USER_EXPFIL_PREDTAB_ATTRIBUTES View
9.10
USER_EXPFIL_PRIVILEGES View
A
Managing Expressions Defined on One or More Database Tables
B
Application Examples
C
Installing Oracle Expression Filter
Index