Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as Plain Text by TT ( 13 years ago )
Insert into "TIMES" ("TIME_ID","DAY_NAME","DAY_NUMBER_IN_WEEK","DAY_NUMBER_IN_MONTH","CALENDAR_WEEK_NUMBER","FISCAL_WEEK_NUMBER","WEEK_ENDING_DAY","WEEK_ENDING_DAY_ID","CALENDAR_MONTH_NUMBER","FISCAL_MONTH_NUMBER","CALENDAR_MONTH_DESC","CALENDAR_MONTH_ID","FISCAL_MONTH_DESC","FISCAL_MONTH_ID","DAYS_IN_CAL_MONTH","DAYS_IN_FIS_MONTH","END_OF_CAL_MONTH","END_OF_FIS_MONTH","CALENDAR_MONTH_NAME","FISCAL_MONTH_NAME","CALENDAR_QUARTER_DESC","CALENDAR_QUARTER_ID","FISCAL_QUARTER_DESC","FISCAL_QUARTER_ID","DAYS_IN_CAL_QUARTER","DAYS_IN_FIS_QUARTER","END_OF_CAL_QUARTER","END_OF_FIS_QUARTER","CALENDAR_QUARTER_NUMBER","FISCAL_QUARTER_NUMBER","CALENDAR_YEAR","CALENDAR_YEAR_ID","FISCAL_YEAR","FISCAL_YEAR_ID","DAYS_IN_CAL_YEAR","DAYS_IN_FIS_YEAR","END_OF_CAL_YEAR","END_OF_FIS_YEAR") values (to_date('1999-01-15','YYYY-MM-DD'),'Friday',5,15,2,2,to_date('1999-01-17','YYYY-MM-DD'),1574,1,1,'1999-01',1684,'1999-01',1732,31,35,to_date('1999-01-31','YYYY-MM-DD'),to_date('1999-01-31','YYYY-MM-DD'),'January','January','1999-01',1773,'1999-01',1789,90,91,to_date('1999-03-31','YYYY-MM-DD'),to_date('1999-03-28','YYYY-MM-DD'),1,1,1999,1803,1999,1807,365,364,to_date('1999-12-31','YYYY-MM-DD'),to_date('1999-12-26','YYYY-MM-DD'));

 

Revise this Paste

Children: 68657
Your Name: Code Language: