Difference between revisions of "SH.CAL MONTH SALES MV (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.CAL_MONTH_SALES_MV
 
| SH.CAL_MONTH_SALES_MV
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| CALENDAR_MONTH_DESC
 
| CALENDAR_MONTH_DESC
 
| VARCHAR2(8)
 
| VARCHAR2(8)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DOLLARS
 
| DOLLARS
 
| NUMBER
 
| NUMBER
Line 38: Line 36:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| SYS_C005197
 
| SYS_C005197
 
| "CALENDAR_MONTH_DESC" IS NOT NULL
 
| "CALENDAR_MONTH_DESC" IS NOT NULL
 
|  
 
|  
 
|}
 
|}

Latest revision as of 06:16, 24 June 2010

wikibot[edit]

Table SH.CAL_MONTH_SALES_MV

Columns[edit]

Column Data Type Nullable Default Description
CALENDAR_MONTH_DESC VARCHAR2(8) not null
DOLLARS NUMBER null

Check Constraints[edit]

Check Constraint Expression Description
SYS_C005197 "CALENDAR_MONTH_DESC" IS NOT NULL