Skip Headers

Oracle® Database Application Developer's Guide - Expression Filter
10g Release 1 (10.1)

Part Number B10821-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to next page
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