Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

SH


Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

CAL_MONTH_SALES_MV

Description

snapshot table for snapshot SH.CAL_MONTH_SALES_MV

Columns

Column Datatype Nullable Default value Comment
CALENDAR_MONTH_DESC VARCHAR2(8) N    
DOLLARS NUMBER(,) Y    

Check constraints

Check constraint Check condition
SYS_C002537 "CALENDAR_MONTH_DESC" IS NOT NULL

Indexes

Index Type Uniqueness Columns
I_SNAP$_CAL_MONTH_SALES_MV FUNCTION-BASED NORMAL UNIQUE  

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N


Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005