Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_OLAP , 22 of 26


SYSTEM.MVIEW_FILTER

Table 34-23 SYSTEM.MVIEW_FILTER
Column  NULL?  Datatype  Description 

FILTERID 

NOT NULL 

NUMBER 

Unique number used to identify the operation that used this filter 

SUBFILTERNUM 

NOT NULL 

NUMBER 

A unique id number that groups all filter items together. A corresponding filter header record can be found in the MVIEW_LOG table 

SUBFILTERTYPE 

 

VARCHAR2(12) 

Filter item number 

STR_VALUE 

 

VARCHAR2(1028) 

String attribute for items that require strings 

NUM_VALUE1 

 

NUMBER 

Numeric low for items that require numbers 

NUM_VALUE2 

 

NUMBER 

Numeric high for items that require numbers 

DATE_VALUE1 

 

DATE 

Date low for items that require dates 

DATE_VALUE2 

 

DATE 

Date high for items that require dates 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback