Hi,

I have a good experience of MS Analysis services and using
its cubes.

My question is how can I programmaticaly access
ORACLE OLAP cubes. Can you please give me a simple
java code to query and display the resultset of the cube.

Is Oracle 9i Olap technology have bugs as I have heard??
Can you please tell how to configure a 9i Olap cube
and access it in my front end applications.

Thanks


Thanks

hello a reader from pk, could you plz contact me on my email add?
shukrya

its rabeila@yahoo.com

its rabeila@yahoo.com

This is very useful for me .
Please Explain about "OLCP"..

Regards,
Veeresh

Hi,

Can you please give a detailed comparison on the OLAP
solutions provided by Microsoft And Oracle. Specifically
between MS analysis services 2000 and Oracle 9i Olap,
MDX (Multidimensional Expressions) language and Oracle
equivalent to MDX.

Thanks

Tom

We are starting to use Oracle 9i OLAP. We have a lot of time-series and analysis reports that have become slow now as the data is growing. So our plan is to move to 9i OLAP and design OLAP schema and materialized views.

I have been reading couple of Oracle OLAP and manuals, n getting a feel of it. But after a lot of reading I still can't visualise exactly what n how things are done using OLAP. (We are not planning to use Analytic Workspaces). I guess it is because I didn't find any straighforward example/Case Study that can help understand things better. Cld you pls point me to some nice examples/articles.

Thanks!


BANNER
------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

 you have access to all the material available on the subject matter. Additionally, you can look at the self-service education for OWB at  

but if they are interested in true olap, then:

OLAP from the outside starts at 

Tutorial for deploying OLAP objects is found at 

OWB OLAP cube creation  

OWB Dimnensional Modeling 

Tom,

I have couple of questions:

1) I am interested in Oracle OLAP instructor-led course. Could you please suggest me a good one.
2) I couldn't find a forum for OLAP on OTN, is it not a seperate forum. If yes, which forum should I check out ?
3) Is there any good book out on Oracle OLAP ?

Thanks

Tom

Links that you forwarded were very useful.

Can you help me with a small case study that I am trying to solve to understand the concept better.

We deal with lots of small securities (loans) everyday. We generate Time Series reports from this data, most of the times we look at Market Values and Duration of the securities at aggregated level.

Everyday we get thousands of securities, each having a type, category, coupon and an amount. E.g.

Sec Id Type Category Coupon Amount Date
100 Arm SF_ARMS 5.0 $1200 04/27/05
101 Arm SF_ARMS_TREASURY5.5 $2000 04/27/05
102 Fixed SHORT_TERM 5.5 $1800 04/27/05
103 Fixed LONG_TERM 6.0 $1000 04/27/05

Sec Id Market_Value Duration Market Calc Batch Date
100 1350 3.12 M1 C1 B1 04/28/05
101 2100 2.5 M2 C1 B1 04/28/05
102 1900 3.0 M1 C1 B1 04/28/05
103 1100 2.7 M1 C1 B1 04/28/05

I have to produce a report like this:

Market Value Duration
Arm
SF_ARMS X X
SF_ARMS_TREASURY X X
Fixed
SHORT_TERM X X
LONG_TERM X X

Can you help me solving this small case study. My questions are:

1) Dimensions I have identified are: Securities, Market, Calculator, Batch, Time.
2) Do we need two separate fact tables for Market value and Duration ? Or they can be in one ?
3) Should Amount and coupon be security attributes or sit in a separate fact table. According to one book any numerical values should go into a fact table.
4) What about Type and Category, are these attributes of Security Dimension.

Any guidance in this direction will be highly appreciated.

Thanks a ton for your valuable time and help.

Hi Tom,
I have question regarding finding Seasonal growth rate in a date range.

Lets say I have a table T1
col1 date ( conatins date )
col2 number ( contains daily sales data )

The table has daily sales data say from 01/01/1995 to 12/31/2005. ( 10 yrs of daily data , excluding sat/sun/or any holiday, assume that the store is closed on weekends and holidays ).

T1
-----
01/01/1995 100
01/02/1995 120
01/03/1995 130
01/04/1995 90
....
01/01/2005 150
01/03/2005 120
..etc

I want to figure out which continuous range of days ( varing from 10 to 20 ) in the past 10 yrs had the excellent % growth rate in the sales data. ( the sales data increasing e.g 10 to 30 to 60 is better than from 1000 to 1010. I want to find out the continuous range of dates in past 10 yrs which had max growth rate ( increasing number of percentage change ).

assumption:
1) since its daily data and since we do not have data for weekends that date range can be approx.
2) if the varying dynamic range is not posible then ateast a fix range say top 15 days ( date range e.g Feb 02 to feb 17 ) of the year where the % growth is highest.

Is this possible and how.
I have spent alot of time on this and finaly gave up..
Please help,

Hi Tom,
I am really very sorry for not providing you with adequate inputs....

say we are looking at any 10 day range
then % growth = ( ( Value at 10th day - Value at 0th day ) / Value 0th day ) * 100.
This is give the growth rate from the begining date to the end
date for those 10 days.

What I am also looking along with the max value is that the consistency growth rate should be >= 70 %.
meaning that the growth rate should be increasing and above 0 ( with varying % ) for atleast 7 out of
10 yrs during that time period, this way I get the consitent best time of the year for positive % growth rate for
the business.

e.g of output 5 columns

start date | end date | year | %growth | $diff( Value at 10th day,for 10 dayrange - Value at 0th day )
02/01/2005 | 02/10/2005 | 2005 | 2% | 20
02/01/2004 | 02/10/2004 | 2004 | 3% | 30
02/01/2003 | 02/10/2003 | 2003 | 0.1% | 2
....
atleast 7 of the 10 yrs should have positive % growth rate.

Thanks in advance,

I am not that expert in analytical functions.
I am attaching the create table and temp data for 2 years ( 2004 and 2005 ) can you show me a working example which will find the approx 15 best days ( date range ) where % growth rate was highest and both years % growth positive.

Again thank yopu very much in advance.

CREATE TABLE T1 ( Dt Date, NSALES Number(12,2));

Insert into T1 Values (TO_DATE('01/01/2004', 'MM/DD/YYYY'), 65.78);
Insert into T1 Values (TO_DATE('01/02/2004', 'MM/DD/YYYY'), 428.83);
Insert into T1 Values (TO_DATE('01/03/2004', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('01/04/2004', 'MM/DD/YYYY'), 1.43);
Insert into T1 Values (TO_DATE('01/05/2004', 'MM/DD/YYYY'), 564.48);
Insert into T1 Values (TO_DATE('01/06/2004', 'MM/DD/YYYY'), 669.26);
Insert into T1 Values (TO_DATE('01/07/2004', 'MM/DD/YYYY'), 678.39);
Insert into T1 Values (TO_DATE('01/08/2004', 'MM/DD/YYYY'), 760.13);
Insert into T1 Values (TO_DATE('01/09/2004', 'MM/DD/YYYY'), 568.83);
Insert into T1 Values (TO_DATE('01/10/2004', 'MM/DD/YYYY'), 16.65);
Insert into T1 Values (TO_DATE('01/11/2004', 'MM/DD/YYYY'), 11.43);
Insert into T1 Values (TO_DATE('01/12/2004', 'MM/DD/YYYY'), 560.13);
Insert into T1 Values (TO_DATE('01/13/2004', 'MM/DD/YYYY'), 634.91);
Insert into T1 Values (TO_DATE('01/14/2004', 'MM/DD/YYYY'), 567.96);
Insert into T1 Values (TO_DATE('01/15/2004', 'MM/DD/YYYY'), 499.7);
Insert into T1 Values (TO_DATE('01/16/2004', 'MM/DD/YYYY'), 533.17);
Insert into T1 Values (TO_DATE('01/17/2004', 'MM/DD/YYYY'), 14.91);
Insert into T1 Values (TO_DATE('01/18/2004', 'MM/DD/YYYY'), 4.91);
Insert into T1 Values (TO_DATE('01/19/2004', 'MM/DD/YYYY'), 221);
Insert into T1 Values (TO_DATE('01/20/2004', 'MM/DD/YYYY'), 896.22);
Insert into T1 Values (TO_DATE('01/21/2004', 'MM/DD/YYYY'), 630.57);
Insert into T1 Values (TO_DATE('01/22/2004', 'MM/DD/YYYY'), 755.78);
Insert into T1 Values (TO_DATE('01/23/2004', 'MM/DD/YYYY'), 505.35);
Insert into T1 Values (TO_DATE('01/24/2004', 'MM/DD/YYYY'), 57.09);
Insert into T1 Values (TO_DATE('01/25/2004', 'MM/DD/YYYY'), 2.74);
Insert into T1 Values (TO_DATE('01/26/2004', 'MM/DD/YYYY'), 706.65);
Insert into T1 Values (TO_DATE('01/27/2004', 'MM/DD/YYYY'), 562.3);
Insert into T1 Values (TO_DATE('01/28/2004', 'MM/DD/YYYY'), 610.13);
Insert into T1 Values (TO_DATE('01/29/2004', 'MM/DD/YYYY'), 556.22);
Insert into T1 Values (TO_DATE('01/30/2004', 'MM/DD/YYYY'), 581.87);
Insert into T1 Values (TO_DATE('01/31/2004', 'MM/DD/YYYY'), 121.43);
Insert into T1 Values (TO_DATE('02/01/2004', 'MM/DD/YYYY'), 5.78);
Insert into T1 Values (TO_DATE('02/02/2004', 'MM/DD/YYYY'), 384.91);
Insert into T1 Values (TO_DATE('02/03/2004', 'MM/DD/YYYY'), 810.13);
Insert into T1 Values (TO_DATE('02/04/2004', 'MM/DD/YYYY'), 750.57);
Insert into T1 Values (TO_DATE('02/05/2004', 'MM/DD/YYYY'), 719.7);
Insert into T1 Values (TO_DATE('02/06/2004', 'MM/DD/YYYY'), 722.74);
Insert into T1 Values (TO_DATE('02/07/2004', 'MM/DD/YYYY'), 127.09);
Insert into T1 Values (TO_DATE('02/08/2004', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('02/09/2004', 'MM/DD/YYYY'), 731.43);
Insert into T1 Values (TO_DATE('02/10/2004', 'MM/DD/YYYY'), 601.87);
Insert into T1 Values (TO_DATE('02/11/2004', 'MM/DD/YYYY'), 628.83);
Insert into T1 Values (TO_DATE('02/12/2004', 'MM/DD/YYYY'), 587.52);
Insert into T1 Values (TO_DATE('02/13/2004', 'MM/DD/YYYY'), 494.91);
Insert into T1 Values (TO_DATE('02/14/2004', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('02/15/2004', 'MM/DD/YYYY'), 6.22);
Insert into T1 Values (TO_DATE('02/16/2004', 'MM/DD/YYYY'), 419.26);
Insert into T1 Values (TO_DATE('02/17/2004', 'MM/DD/YYYY'), 539.26);
Insert into T1 Values (TO_DATE('02/18/2004', 'MM/DD/YYYY'), 569.7);
Insert into T1 Values (TO_DATE('02/19/2004', 'MM/DD/YYYY'), 762.3);
Insert into T1 Values (TO_DATE('02/20/2004', 'MM/DD/YYYY'), 617.96);
Insert into T1 Values (TO_DATE('02/21/2004', 'MM/DD/YYYY'), 11);
Insert into T1 Values (TO_DATE('02/23/2004', 'MM/DD/YYYY'), 552.3);
Insert into T1 Values (TO_DATE('02/24/2004', 'MM/DD/YYYY'), 763.17);
Insert into T1 Values (TO_DATE('02/25/2004', 'MM/DD/YYYY'), 574.91);
Insert into T1 Values (TO_DATE('02/26/2004', 'MM/DD/YYYY'), 636.22);
Insert into T1 Values (TO_DATE('02/27/2004', 'MM/DD/YYYY'), 460.57);
Insert into T1 Values (TO_DATE('02/28/2004', 'MM/DD/YYYY'), 121.43);
Insert into T1 Values (TO_DATE('02/29/2004', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('03/01/2004', 'MM/DD/YYYY'), 746.65);
Insert into T1 Values (TO_DATE('03/02/2004', 'MM/DD/YYYY'), 737.96);
Insert into T1 Values (TO_DATE('03/03/2004', 'MM/DD/YYYY'), 679.26);
Insert into T1 Values (TO_DATE('03/04/2004', 'MM/DD/YYYY'), 705.78);
Insert into T1 Values (TO_DATE('03/05/2004', 'MM/DD/YYYY'), 701.87);
Insert into T1 Values (TO_DATE('03/06/2004', 'MM/DD/YYYY'), 29.7);
Insert into T1 Values (TO_DATE('03/07/2004', 'MM/DD/YYYY'), 5.78);
Insert into T1 Values (TO_DATE('03/08/2004', 'MM/DD/YYYY'), 644.91);
Insert into T1 Values (TO_DATE('03/09/2004', 'MM/DD/YYYY'), 728.39);
Insert into T1 Values (TO_DATE('03/10/2004', 'MM/DD/YYYY'), 726.65);
Insert into T1 Values (TO_DATE('03/11/2004', 'MM/DD/YYYY'), 511);
Insert into T1 Values (TO_DATE('03/12/2004', 'MM/DD/YYYY'), 585.78);
Insert into T1 Values (TO_DATE('03/13/2004', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('03/14/2004', 'MM/DD/YYYY'), 8.39);
Insert into T1 Values (TO_DATE('03/15/2004', 'MM/DD/YYYY'), 898.39);
Insert into T1 Values (TO_DATE('03/16/2004', 'MM/DD/YYYY'), 727.52);
Insert into T1 Values (TO_DATE('03/17/2004', 'MM/DD/YYYY'), 560.13);
Insert into T1 Values (TO_DATE('03/18/2004', 'MM/DD/YYYY'), 872.74);
Insert into T1 Values (TO_DATE('03/19/2004', 'MM/DD/YYYY'), 530.13);
Insert into T1 Values (TO_DATE('03/20/2004', 'MM/DD/YYYY'), 1.43);
Insert into T1 Values (TO_DATE('03/21/2004', 'MM/DD/YYYY'), 4.48);
Insert into T1 Values (TO_DATE('03/22/2004', 'MM/DD/YYYY'), 683.61);
Insert into T1 Values (TO_DATE('03/23/2004', 'MM/DD/YYYY'), 814.91);
Insert into T1 Values (TO_DATE('03/24/2004', 'MM/DD/YYYY'), 784.91);
Insert into T1 Values (TO_DATE('03/25/2004', 'MM/DD/YYYY'), 785.78);
Insert into T1 Values (TO_DATE('03/26/2004', 'MM/DD/YYYY'), 613.61);
Insert into T1 Values (TO_DATE('03/27/2004', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('03/28/2004', 'MM/DD/YYYY'), 13.17);
Insert into T1 Values (TO_DATE('03/29/2004', 'MM/DD/YYYY'), 715.78);
Insert into T1 Values (TO_DATE('03/30/2004', 'MM/DD/YYYY'), 714.91);
Insert into T1 Values (TO_DATE('03/31/2004', 'MM/DD/YYYY'), 897.09);
Insert into T1 Values (TO_DATE('04/01/2004', 'MM/DD/YYYY'), 941);
Insert into T1 Values (TO_DATE('04/02/2004', 'MM/DD/YYYY'), 577.52);
Insert into T1 Values (TO_DATE('04/03/2004', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('04/04/2004', 'MM/DD/YYYY'), 4.48);
Insert into T1 Values (TO_DATE('04/05/2004', 'MM/DD/YYYY'), 648.39);
Insert into T1 Values (TO_DATE('04/06/2004', 'MM/DD/YYYY'), 667.52);
Insert into T1 Values (TO_DATE('04/07/2004', 'MM/DD/YYYY'), 620.57);
Insert into T1 Values (TO_DATE('04/08/2004', 'MM/DD/YYYY'), 895.78);
Insert into T1 Values (TO_DATE('04/09/2004', 'MM/DD/YYYY'), 295.78);
Insert into T1 Values (TO_DATE('04/10/2004', 'MM/DD/YYYY'), 239.26);
Insert into T1 Values (TO_DATE('04/12/2004', 'MM/DD/YYYY'), 941.87);
Insert into T1 Values (TO_DATE('04/13/2004', 'MM/DD/YYYY'), 681.43);
Insert into T1 Values (TO_DATE('04/14/2004', 'MM/DD/YYYY'), 855.78);
Insert into T1 Values (TO_DATE('04/15/2004', 'MM/DD/YYYY'), 603.17);
Insert into T1 Values (TO_DATE('04/16/2004', 'MM/DD/YYYY'), 541.87);
Insert into T1 Values (TO_DATE('04/17/2004', 'MM/DD/YYYY'), 44.48);
Insert into T1 Values (TO_DATE('04/18/2004', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('04/19/2004', 'MM/DD/YYYY'), 619.7);
Insert into T1 Values (TO_DATE('04/20/2004', 'MM/DD/YYYY'), 690.57);
Insert into T1 Values (TO_DATE('04/21/2004', 'MM/DD/YYYY'), 764.48);
Insert into T1 Values (TO_DATE('04/22/2004', 'MM/DD/YYYY'), 505.78);
Insert into T1 Values (TO_DATE('04/23/2004', 'MM/DD/YYYY'), 517.96);
Insert into T1 Values (TO_DATE('04/24/2004', 'MM/DD/YYYY'), 34.48);
Insert into T1 Values (TO_DATE('04/25/2004', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('04/26/2004', 'MM/DD/YYYY'), 759.7);
Insert into T1 Values (TO_DATE('04/27/2004', 'MM/DD/YYYY'), 962.74);
Insert into T1 Values (TO_DATE('04/28/2004', 'MM/DD/YYYY'), 679.7);
Insert into T1 Values (TO_DATE('04/29/2004', 'MM/DD/YYYY'), 640.13);
Insert into T1 Values (TO_DATE('04/30/2004', 'MM/DD/YYYY'), 898.39);
Insert into T1 Values (TO_DATE('05/01/2004', 'MM/DD/YYYY'), 7.52);
Insert into T1 Values (TO_DATE('05/02/2004', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('05/03/2004', 'MM/DD/YYYY'), 705.78);
Insert into T1 Values (TO_DATE('05/04/2004', 'MM/DD/YYYY'), 689.7);
Insert into T1 Values (TO_DATE('05/05/2004', 'MM/DD/YYYY'), 681.87);
Insert into T1 Values (TO_DATE('05/06/2004', 'MM/DD/YYYY'), 601);
Insert into T1 Values (TO_DATE('05/07/2004', 'MM/DD/YYYY'), 508.83);
Insert into T1 Values (TO_DATE('05/08/2004', 'MM/DD/YYYY'), 20.13);
Insert into T1 Values (TO_DATE('05/09/2004', 'MM/DD/YYYY'), 11.43);
Insert into T1 Values (TO_DATE('05/10/2004', 'MM/DD/YYYY'), 2352.3);
Insert into T1 Values (TO_DATE('05/11/2004', 'MM/DD/YYYY'), 758.83);
Insert into T1 Values (TO_DATE('05/12/2004', 'MM/DD/YYYY'), 672.3);
Insert into T1 Values (TO_DATE('05/13/2004', 'MM/DD/YYYY'), 690.13);
Insert into T1 Values (TO_DATE('05/14/2004', 'MM/DD/YYYY'), 589.26);
Insert into T1 Values (TO_DATE('05/15/2004', 'MM/DD/YYYY'), 35.78);
Insert into T1 Values (TO_DATE('05/16/2004', 'MM/DD/YYYY'), 11.43);
Insert into T1 Values (TO_DATE('05/17/2004', 'MM/DD/YYYY'), 600.13);
Insert into T1 Values (TO_DATE('05/18/2004', 'MM/DD/YYYY'), 680.57);
Insert into T1 Values (TO_DATE('05/19/2004', 'MM/DD/YYYY'), 654.48);
Insert into T1 Values (TO_DATE('05/20/2004', 'MM/DD/YYYY'), 629.7);
Insert into T1 Values (TO_DATE('05/21/2004', 'MM/DD/YYYY'), 1104.91);
Insert into T1 Values (TO_DATE('05/22/2004', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('05/23/2004', 'MM/DD/YYYY'), 4.48);
Insert into T1 Values (TO_DATE('05/24/2004', 'MM/DD/YYYY'), 752.3);
Insert into T1 Values (TO_DATE('05/25/2004', 'MM/DD/YYYY'), 877.52);
Insert into T1 Values (TO_DATE('05/26/2004', 'MM/DD/YYYY'), 753.61);
Insert into T1 Values (TO_DATE('05/27/2004', 'MM/DD/YYYY'), 505.78);
Insert into T1 Values (TO_DATE('05/28/2004', 'MM/DD/YYYY'), 524.48);
Insert into T1 Values (TO_DATE('05/29/2004', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('05/30/2004', 'MM/DD/YYYY'), 1.43);
Insert into T1 Values (TO_DATE('05/31/2004', 'MM/DD/YYYY'), 228.39);
Insert into T1 Values (TO_DATE('06/01/2004', 'MM/DD/YYYY'), 569.7);
Insert into T1 Values (TO_DATE('06/02/2004', 'MM/DD/YYYY'), 544.04);
Insert into T1 Values (TO_DATE('06/03/2004', 'MM/DD/YYYY'), 576.65);
Insert into T1 Values (TO_DATE('06/04/2004', 'MM/DD/YYYY'), 481);
Insert into T1 Values (TO_DATE('06/05/2004', 'MM/DD/YYYY'), 34.91);
Insert into T1 Values (TO_DATE('06/06/2004', 'MM/DD/YYYY'), 1.43);
Insert into T1 Values (TO_DATE('06/07/2004', 'MM/DD/YYYY'), 568.83);
Insert into T1 Values (TO_DATE('06/08/2004', 'MM/DD/YYYY'), 684.04);
Insert into T1 Values (TO_DATE('06/09/2004', 'MM/DD/YYYY'), 674.48);
Insert into T1 Values (TO_DATE('06/10/2004', 'MM/DD/YYYY'), 764.04);
Insert into T1 Values (TO_DATE('06/11/2004', 'MM/DD/YYYY'), 492.3);
Insert into T1 Values (TO_DATE('06/12/2004', 'MM/DD/YYYY'), 10.13);
Insert into T1 Values (TO_DATE('06/13/2004', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('06/14/2004', 'MM/DD/YYYY'), 742.3);
Insert into T1 Values (TO_DATE('06/15/2004', 'MM/DD/YYYY'), 727.52);
Insert into T1 Values (TO_DATE('06/16/2004', 'MM/DD/YYYY'), 684.04);
Insert into T1 Values (TO_DATE('06/17/2004', 'MM/DD/YYYY'), 743.17);
Insert into T1 Values (TO_DATE('06/18/2004', 'MM/DD/YYYY'), 573.17);
Insert into T1 Values (TO_DATE('06/19/2004', 'MM/DD/YYYY'), 10.13);
Insert into T1 Values (TO_DATE('06/20/2004', 'MM/DD/YYYY'), 4.48);
Insert into T1 Values (TO_DATE('06/21/2004', 'MM/DD/YYYY'), 839.26);
Insert into T1 Values (TO_DATE('06/22/2004', 'MM/DD/YYYY'), 789.26);
Insert into T1 Values (TO_DATE('06/23/2004', 'MM/DD/YYYY'), 830.57);
Insert into T1 Values (TO_DATE('06/24/2004', 'MM/DD/YYYY'), 587.96);
Insert into T1 Values (TO_DATE('06/25/2004', 'MM/DD/YYYY'), 1753.17);
Insert into T1 Values (TO_DATE('06/26/2004', 'MM/DD/YYYY'), 22.3);
Insert into T1 Values (TO_DATE('06/27/2004', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('06/28/2004', 'MM/DD/YYYY'), 631);
Insert into T1 Values (TO_DATE('06/29/2004', 'MM/DD/YYYY'), 895.35);
Insert into T1 Values (TO_DATE('06/30/2004', 'MM/DD/YYYY'), 749.26);
Insert into T1 Values (TO_DATE('07/01/2004', 'MM/DD/YYYY'), 768.83);
Insert into T1 Values (TO_DATE('07/02/2004', 'MM/DD/YYYY'), 526.22);
Insert into T1 Values (TO_DATE('07/03/2004', 'MM/DD/YYYY'), 46.65);
Insert into T1 Values (TO_DATE('07/05/2004', 'MM/DD/YYYY'), 4.91);
Insert into T1 Values (TO_DATE('07/06/2004', 'MM/DD/YYYY'), 598.83);
Insert into T1 Values (TO_DATE('07/07/2004', 'MM/DD/YYYY'), 737.96);
Insert into T1 Values (TO_DATE('07/08/2004', 'MM/DD/YYYY'), 716.22);
Insert into T1 Values (TO_DATE('07/09/2004', 'MM/DD/YYYY'), 508.39);
Insert into T1 Values (TO_DATE('07/10/2004', 'MM/DD/YYYY'), 117.52);
Insert into T1 Values (TO_DATE('07/11/2004', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('07/12/2004', 'MM/DD/YYYY'), 655.35);
Insert into T1 Values (TO_DATE('07/13/2004', 'MM/DD/YYYY'), 661.87);
Insert into T1 Values (TO_DATE('07/14/2004', 'MM/DD/YYYY'), 689.7);
Insert into T1 Values (TO_DATE('07/15/2004', 'MM/DD/YYYY'), 601.87);
Insert into T1 Values (TO_DATE('07/16/2004', 'MM/DD/YYYY'), 2514.48);
Insert into T1 Values (TO_DATE('07/17/2004', 'MM/DD/YYYY'), 2004.04);
Insert into T1 Values (TO_DATE('07/18/2004', 'MM/DD/YYYY'), 2.3);
Insert into T1 Values (TO_DATE('07/19/2004', 'MM/DD/YYYY'), 617.09);
Insert into T1 Values (TO_DATE('07/20/2004', 'MM/DD/YYYY'), 784.91);
Insert into T1 Values (TO_DATE('07/21/2004', 'MM/DD/YYYY'), 878.39);
Insert into T1 Values (TO_DATE('07/22/2004', 'MM/DD/YYYY'), 647.96);
Insert into T1 Values (TO_DATE('07/23/2004', 'MM/DD/YYYY'), 480.13);
Insert into T1 Values (TO_DATE('07/24/2004', 'MM/DD/YYYY'), 24.48);
Insert into T1 Values (TO_DATE('07/25/2004', 'MM/DD/YYYY'), 2.74);
Insert into T1 Values (TO_DATE('07/26/2004', 'MM/DD/YYYY'), 519.26);
Insert into T1 Values (TO_DATE('07/27/2004', 'MM/DD/YYYY'), 681.87);
Insert into T1 Values (TO_DATE('07/28/2004', 'MM/DD/YYYY'), 667.52);
Insert into T1 Values (TO_DATE('07/29/2004', 'MM/DD/YYYY'), 1365.78);
Insert into T1 Values (TO_DATE('07/30/2004', 'MM/DD/YYYY'), 583.17);
Insert into T1 Values (TO_DATE('07/31/2004', 'MM/DD/YYYY'), 15.35);
Insert into T1 Values (TO_DATE('08/01/2004', 'MM/DD/YYYY'), 2.74);
Insert into T1 Values (TO_DATE('08/02/2004', 'MM/DD/YYYY'), 760.13);
Insert into T1 Values (TO_DATE('08/03/2004', 'MM/DD/YYYY'), 699.26);
Insert into T1 Values (TO_DATE('08/04/2004', 'MM/DD/YYYY'), 745.35);
Insert into T1 Values (TO_DATE('08/05/2004', 'MM/DD/YYYY'), 783.17);
Insert into T1 Values (TO_DATE('08/06/2004', 'MM/DD/YYYY'), 1794.04);
Insert into T1 Values (TO_DATE('08/07/2004', 'MM/DD/YYYY'), 4.04);
Insert into T1 Values (TO_DATE('08/08/2004', 'MM/DD/YYYY'), 6.65);
Insert into T1 Values (TO_DATE('08/09/2004', 'MM/DD/YYYY'), 701);
Insert into T1 Values (TO_DATE('08/10/2004', 'MM/DD/YYYY'), 934.91);
Insert into T1 Values (TO_DATE('08/11/2004', 'MM/DD/YYYY'), 922.74);
Insert into T1 Values (TO_DATE('08/12/2004', 'MM/DD/YYYY'), 676.22);
Insert into T1 Values (TO_DATE('08/13/2004', 'MM/DD/YYYY'), 528.83);
Insert into T1 Values (TO_DATE('08/14/2004', 'MM/DD/YYYY'), 24.91);
Insert into T1 Values (TO_DATE('08/15/2004', 'MM/DD/YYYY'), 6.22);
Insert into T1 Values (TO_DATE('08/16/2004', 'MM/DD/YYYY'), 720.57);
Insert into T1 Values (TO_DATE('08/17/2004', 'MM/DD/YYYY'), 813.61);
Insert into T1 Values (TO_DATE('08/18/2004', 'MM/DD/YYYY'), 748.39);
Insert into T1 Values (TO_DATE('08/19/2004', 'MM/DD/YYYY'), 732.3);
Insert into T1 Values (TO_DATE('08/20/2004', 'MM/DD/YYYY'), 511.87);
Insert into T1 Values (TO_DATE('08/21/2004', 'MM/DD/YYYY'), 14.91);
Insert into T1 Values (TO_DATE('08/22/2004', 'MM/DD/YYYY'), 7.96);
Insert into T1 Values (TO_DATE('08/23/2004', 'MM/DD/YYYY'), 749.7);
Insert into T1 Values (TO_DATE('08/24/2004', 'MM/DD/YYYY'), 676.22);
Insert into T1 Values (TO_DATE('08/25/2004', 'MM/DD/YYYY'), 692.3);
Insert into T1 Values (TO_DATE('08/26/2004', 'MM/DD/YYYY'), 1216.22);
Insert into T1 Values (TO_DATE('08/27/2004', 'MM/DD/YYYY'), 830.13);
Insert into T1 Values (TO_DATE('08/28/2004', 'MM/DD/YYYY'), 38.39);
Insert into T1 Values (TO_DATE('08/29/2004', 'MM/DD/YYYY'), 9.26);
Insert into T1 Values (TO_DATE('08/30/2004', 'MM/DD/YYYY'), 830.57);
Insert into T1 Values (TO_DATE('08/31/2004', 'MM/DD/YYYY'), 715.78);
Insert into T1 Values (TO_DATE('09/01/2004', 'MM/DD/YYYY'), 773.17);
Insert into T1 Values (TO_DATE('09/02/2004', 'MM/DD/YYYY'), 959.7);
Insert into T1 Values (TO_DATE('09/03/2004', 'MM/DD/YYYY'), 542.74);
Insert into T1 Values (TO_DATE('09/04/2004', 'MM/DD/YYYY'), 19.26);
Insert into T1 Values (TO_DATE('09/05/2004', 'MM/DD/YYYY'), 7.52);
Insert into T1 Values (TO_DATE('09/06/2004', 'MM/DD/YYYY'), 11);
Insert into T1 Values (TO_DATE('09/07/2004', 'MM/DD/YYYY'), 681.87);
Insert into T1 Values (TO_DATE('09/08/2004', 'MM/DD/YYYY'), 807.09);
Insert into T1 Values (TO_DATE('09/09/2004', 'MM/DD/YYYY'), 777.52);
Insert into T1 Values (TO_DATE('09/10/2004', 'MM/DD/YYYY'), 819.26);
Insert into T1 Values (TO_DATE('09/11/2004', 'MM/DD/YYYY'), 33.61);
Insert into T1 Values (TO_DATE('09/12/2004', 'MM/DD/YYYY'), 18.83);
Insert into T1 Values (TO_DATE('09/13/2004', 'MM/DD/YYYY'), 1108.39);
Insert into T1 Values (TO_DATE('09/14/2004', 'MM/DD/YYYY'), 991);
Insert into T1 Values (TO_DATE('09/15/2004', 'MM/DD/YYYY'), 853.17);
Insert into T1 Values (TO_DATE('09/16/2004', 'MM/DD/YYYY'), 679.7);
Insert into T1 Values (TO_DATE('09/17/2004', 'MM/DD/YYYY'), 903.17);
Insert into T1 Values (TO_DATE('09/18/2004', 'MM/DD/YYYY'), 15.35);
Insert into T1 Values (TO_DATE('09/19/2004', 'MM/DD/YYYY'), 16.22);
Insert into T1 Values (TO_DATE('09/20/2004', 'MM/DD/YYYY'), 780.13);
Insert into T1 Values (TO_DATE('09/21/2004', 'MM/DD/YYYY'), 764.91);
Insert into T1 Values (TO_DATE('09/22/2004', 'MM/DD/YYYY'), 1329.7);
Insert into T1 Values (TO_DATE('09/23/2004', 'MM/DD/YYYY'), 854.04);
Insert into T1 Values (TO_DATE('09/24/2004', 'MM/DD/YYYY'), 767.96);
Insert into T1 Values (TO_DATE('09/25/2004', 'MM/DD/YYYY'), 30.13);
Insert into T1 Values (TO_DATE('09/26/2004', 'MM/DD/YYYY'), 13.17);
Insert into T1 Values (TO_DATE('09/27/2004', 'MM/DD/YYYY'), 1021.43);
Insert into T1 Values (TO_DATE('09/28/2004', 'MM/DD/YYYY'), 767.52);
Insert into T1 Values (TO_DATE('09/29/2004', 'MM/DD/YYYY'), 846.65);
Insert into T1 Values (TO_DATE('09/30/2004', 'MM/DD/YYYY'), 934.04);
Insert into T1 Values (TO_DATE('10/01/2004', 'MM/DD/YYYY'), 713.61);
Insert into T1 Values (TO_DATE('10/02/2004', 'MM/DD/YYYY'), 9.26);
Insert into T1 Values (TO_DATE('10/03/2004', 'MM/DD/YYYY'), 4.91);
Insert into T1 Values (TO_DATE('10/04/2004', 'MM/DD/YYYY'), 625.35);
Insert into T1 Values (TO_DATE('10/05/2004', 'MM/DD/YYYY'), 1152.74);
Insert into T1 Values (TO_DATE('10/06/2004', 'MM/DD/YYYY'), 731.87);
Insert into T1 Values (TO_DATE('10/07/2004', 'MM/DD/YYYY'), 780.13);
Insert into T1 Values (TO_DATE('10/08/2004', 'MM/DD/YYYY'), 704.04);
Insert into T1 Values (TO_DATE('10/09/2004', 'MM/DD/YYYY'), 38.39);
Insert into T1 Values (TO_DATE('10/10/2004', 'MM/DD/YYYY'), 1.43);
Insert into T1 Values (TO_DATE('10/11/2004', 'MM/DD/YYYY'), 817.52);
Insert into T1 Values (TO_DATE('10/12/2004', 'MM/DD/YYYY'), 897.96);
Insert into T1 Values (TO_DATE('10/13/2004', 'MM/DD/YYYY'), 856.65);
Insert into T1 Values (TO_DATE('10/14/2004', 'MM/DD/YYYY'), 738.83);
Insert into T1 Values (TO_DATE('10/15/2004', 'MM/DD/YYYY'), 634.04);
Insert into T1 Values (TO_DATE('10/16/2004', 'MM/DD/YYYY'), 22.3);
Insert into T1 Values (TO_DATE('10/17/2004', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('10/18/2004', 'MM/DD/YYYY'), 695.78);
Insert into T1 Values (TO_DATE('10/19/2004', 'MM/DD/YYYY'), 891.43);
Insert into T1 Values (TO_DATE('10/20/2004', 'MM/DD/YYYY'), 741);
Insert into T1 Values (TO_DATE('10/21/2004', 'MM/DD/YYYY'), 794.91);
Insert into T1 Values (TO_DATE('10/22/2004', 'MM/DD/YYYY'), 574.91);
Insert into T1 Values (TO_DATE('10/23/2004', 'MM/DD/YYYY'), 11.87);
Insert into T1 Values (TO_DATE('10/24/2004', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('10/25/2004', 'MM/DD/YYYY'), 814.04);
Insert into T1 Values (TO_DATE('10/26/2004', 'MM/DD/YYYY'), 1242.3);
Insert into T1 Values (TO_DATE('10/27/2004', 'MM/DD/YYYY'), 915.35);
Insert into T1 Values (TO_DATE('10/28/2004', 'MM/DD/YYYY'), 880.57);
Insert into T1 Values (TO_DATE('10/29/2004', 'MM/DD/YYYY'), 728.83);
Insert into T1 Values (TO_DATE('10/30/2004', 'MM/DD/YYYY'), 38.83);
Insert into T1 Values (TO_DATE('10/31/2004', 'MM/DD/YYYY'), 10.13);
Insert into T1 Values (TO_DATE('11/01/2004', 'MM/DD/YYYY'), 685.35);
Insert into T1 Values (TO_DATE('11/02/2004', 'MM/DD/YYYY'), 658.39);
Insert into T1 Values (TO_DATE('11/03/2004', 'MM/DD/YYYY'), 853.61);
Insert into T1 Values (TO_DATE('11/04/2004', 'MM/DD/YYYY'), 771.87);
Insert into T1 Values (TO_DATE('11/05/2004', 'MM/DD/YYYY'), 620.57);
Insert into T1 Values (TO_DATE('11/06/2004', 'MM/DD/YYYY'), 34.48);
Insert into T1 Values (TO_DATE('11/07/2004', 'MM/DD/YYYY'), 7.52);
Insert into T1 Values (TO_DATE('11/08/2004', 'MM/DD/YYYY'), 685.35);
Insert into T1 Values (TO_DATE('11/09/2004', 'MM/DD/YYYY'), 773.17);
Insert into T1 Values (TO_DATE('11/10/2004', 'MM/DD/YYYY'), 723.61);
Insert into T1 Values (TO_DATE('11/11/2004', 'MM/DD/YYYY'), 747.09);
Insert into T1 Values (TO_DATE('11/12/2004', 'MM/DD/YYYY'), 562.74);
Insert into T1 Values (TO_DATE('11/13/2004', 'MM/DD/YYYY'), 44.91);
Insert into T1 Values (TO_DATE('11/14/2004', 'MM/DD/YYYY'), 7.52);
Insert into T1 Values (TO_DATE('11/15/2004', 'MM/DD/YYYY'), 789.26);
Insert into T1 Values (TO_DATE('11/16/2004', 'MM/DD/YYYY'), 701);
Insert into T1 Values (TO_DATE('11/17/2004', 'MM/DD/YYYY'), 829.26);
Insert into T1 Values (TO_DATE('11/18/2004', 'MM/DD/YYYY'), 757.96);
Insert into T1 Values (TO_DATE('11/19/2004', 'MM/DD/YYYY'), 686.22);
Insert into T1 Values (TO_DATE('11/20/2004', 'MM/DD/YYYY'), 51.87);
Insert into T1 Values (TO_DATE('11/21/2004', 'MM/DD/YYYY'), 12.3);
Insert into T1 Values (TO_DATE('11/22/2004', 'MM/DD/YYYY'), 741);
Insert into T1 Values (TO_DATE('11/23/2004', 'MM/DD/YYYY'), 707.09);
Insert into T1 Values (TO_DATE('11/24/2004', 'MM/DD/YYYY'), 548.39);
Insert into T1 Values (TO_DATE('11/25/2004', 'MM/DD/YYYY'), 27.52);
Insert into T1 Values (TO_DATE('11/26/2004', 'MM/DD/YYYY'), 106.22);
Insert into T1 Values (TO_DATE('11/27/2004', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('11/28/2004', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('11/29/2004', 'MM/DD/YYYY'), 715.78);
Insert into T1 Values (TO_DATE('11/30/2004', 'MM/DD/YYYY'), 781);
Insert into T1 Values (TO_DATE('12/01/2004', 'MM/DD/YYYY'), 711.87);
Insert into T1 Values (TO_DATE('12/02/2004', 'MM/DD/YYYY'), 580.57);
Insert into T1 Values (TO_DATE('12/03/2004', 'MM/DD/YYYY'), 705.35);
Insert into T1 Values (TO_DATE('12/04/2004', 'MM/DD/YYYY'), 18.83);
Insert into T1 Values (TO_DATE('12/05/2004', 'MM/DD/YYYY'), 4.04);
Insert into T1 Values (TO_DATE('12/06/2004', 'MM/DD/YYYY'), 948.39);
Insert into T1 Values (TO_DATE('12/07/2004', 'MM/DD/YYYY'), 1077.96);
Insert into T1 Values (TO_DATE('12/08/2004', 'MM/DD/YYYY'), 906.65);
Insert into T1 Values (TO_DATE('12/09/2004', 'MM/DD/YYYY'), 892.3);
Insert into T1 Values (TO_DATE('12/10/2004', 'MM/DD/YYYY'), 620.57);
Insert into T1 Values (TO_DATE('12/11/2004', 'MM/DD/YYYY'), 104.48);
Insert into T1 Values (TO_DATE('12/12/2004', 'MM/DD/YYYY'), 12.3);
Insert into T1 Values (TO_DATE('12/13/2004', 'MM/DD/YYYY'), 634.04);
Insert into T1 Values (TO_DATE('12/14/2004', 'MM/DD/YYYY'), 878.83);
Insert into T1 Values (TO_DATE('12/15/2004', 'MM/DD/YYYY'), 1517.52);
Insert into T1 Values (TO_DATE('12/16/2004', 'MM/DD/YYYY'), 1181);
Insert into T1 Values (TO_DATE('12/17/2004', 'MM/DD/YYYY'), 1144.48);
Insert into T1 Values (TO_DATE('12/18/2004', 'MM/DD/YYYY'), 159.7);
Insert into T1 Values (TO_DATE('12/19/2004', 'MM/DD/YYYY'), 45.35);
Insert into T1 Values (TO_DATE('12/20/2004', 'MM/DD/YYYY'), 857.52);
Insert into T1 Values (TO_DATE('12/21/2004', 'MM/DD/YYYY'), 1163.61);
Insert into T1 Values (TO_DATE('12/22/2004', 'MM/DD/YYYY'), 684.91);
Insert into T1 Values (TO_DATE('12/23/2004', 'MM/DD/YYYY'), 569.7);
Insert into T1 Values (TO_DATE('12/27/2004', 'MM/DD/YYYY'), 744.48);
Insert into T1 Values (TO_DATE('12/28/2004', 'MM/DD/YYYY'), 1127.09);
Insert into T1 Values (TO_DATE('12/29/2004', 'MM/DD/YYYY'), 924.48);
Insert into T1 Values (TO_DATE('12/30/2004', 'MM/DD/YYYY'), 808.83);
Insert into T1 Values (TO_DATE('12/31/2004', 'MM/DD/YYYY'), 198.39);
COMMIT;

Remaining records for year 2005

Insert into T1 Values (TO_DATE('01/01/2005', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('01/02/2005', 'MM/DD/YYYY'), 30.13);
Insert into T1 Values (TO_DATE('01/03/2005', 'MM/DD/YYYY'), 485.35);
Insert into T1 Values (TO_DATE('01/04/2005', 'MM/DD/YYYY'), 943.61);
Insert into T1 Values (TO_DATE('01/05/2005', 'MM/DD/YYYY'), 897.09);
Insert into T1 Values (TO_DATE('01/06/2005', 'MM/DD/YYYY'), 914.91);
Insert into T1 Values (TO_DATE('01/07/2005', 'MM/DD/YYYY'), 636.22);
Insert into T1 Values (TO_DATE('01/08/2005', 'MM/DD/YYYY'), 19.26);
Insert into T1 Values (TO_DATE('01/09/2005', 'MM/DD/YYYY'), 8.39);
Insert into T1 Values (TO_DATE('01/10/2005', 'MM/DD/YYYY'), 759.7);
Insert into T1 Values (TO_DATE('01/11/2005', 'MM/DD/YYYY'), 707.52);
Insert into T1 Values (TO_DATE('01/12/2005', 'MM/DD/YYYY'), 745.78);
Insert into T1 Values (TO_DATE('01/13/2005', 'MM/DD/YYYY'), 868.83);
Insert into T1 Values (TO_DATE('01/14/2005', 'MM/DD/YYYY'), 673.17);
Insert into T1 Values (TO_DATE('01/15/2005', 'MM/DD/YYYY'), 31.43);
Insert into T1 Values (TO_DATE('01/16/2005', 'MM/DD/YYYY'), 5.78);
Insert into T1 Values (TO_DATE('01/17/2005', 'MM/DD/YYYY'), 358.39);
Insert into T1 Values (TO_DATE('01/18/2005', 'MM/DD/YYYY'), 1241.87);
Insert into T1 Values (TO_DATE('01/19/2005', 'MM/DD/YYYY'), 956.65);
Insert into T1 Values (TO_DATE('01/20/2005', 'MM/DD/YYYY'), 1017.96);
Insert into T1 Values (TO_DATE('01/21/2005', 'MM/DD/YYYY'), 1128.39);
Insert into T1 Values (TO_DATE('01/22/2005', 'MM/DD/YYYY'), 25.35);
Insert into T1 Values (TO_DATE('01/23/2005', 'MM/DD/YYYY'), 26.65);
Insert into T1 Values (TO_DATE('01/24/2005', 'MM/DD/YYYY'), 618.83);
Insert into T1 Values (TO_DATE('01/25/2005', 'MM/DD/YYYY'), 833.17);
Insert into T1 Values (TO_DATE('01/26/2005', 'MM/DD/YYYY'), 798.39);
Insert into T1 Values (TO_DATE('01/27/2005', 'MM/DD/YYYY'), 845.35);
Insert into T1 Values (TO_DATE('01/28/2005', 'MM/DD/YYYY'), 616.22);
Insert into T1 Values (TO_DATE('01/29/2005', 'MM/DD/YYYY'), 37.09);
Insert into T1 Values (TO_DATE('01/30/2005', 'MM/DD/YYYY'), 10.13);
Insert into T1 Values (TO_DATE('01/31/2005', 'MM/DD/YYYY'), 717.96);
Insert into T1 Values (TO_DATE('02/01/2005', 'MM/DD/YYYY'), 721.43);
Insert into T1 Values (TO_DATE('02/02/2005', 'MM/DD/YYYY'), 689.26);
Insert into T1 Values (TO_DATE('02/03/2005', 'MM/DD/YYYY'), 717.96);
Insert into T1 Values (TO_DATE('02/04/2005', 'MM/DD/YYYY'), 606.22);
Insert into T1 Values (TO_DATE('02/05/2005', 'MM/DD/YYYY'), 36.65);
Insert into T1 Values (TO_DATE('02/06/2005', 'MM/DD/YYYY'), 12.3);
Insert into T1 Values (TO_DATE('02/07/2005', 'MM/DD/YYYY'), 632.3);
Insert into T1 Values (TO_DATE('02/08/2005', 'MM/DD/YYYY'), 789.7);
Insert into T1 Values (TO_DATE('02/09/2005', 'MM/DD/YYYY'), 1726.22);
Insert into T1 Values (TO_DATE('02/10/2005', 'MM/DD/YYYY'), 874.91);
Insert into T1 Values (TO_DATE('02/11/2005', 'MM/DD/YYYY'), 590.57);
Insert into T1 Values (TO_DATE('02/12/2005', 'MM/DD/YYYY'), 53.17);
Insert into T1 Values (TO_DATE('02/13/2005', 'MM/DD/YYYY'), 34.48);
Insert into T1 Values (TO_DATE('02/14/2005', 'MM/DD/YYYY'), 731.87);
Insert into T1 Values (TO_DATE('02/15/2005', 'MM/DD/YYYY'), 701.43);
Insert into T1 Values (TO_DATE('02/16/2005', 'MM/DD/YYYY'), 908.39);
Insert into T1 Values (TO_DATE('02/17/2005', 'MM/DD/YYYY'), 886.22);
Insert into T1 Values (TO_DATE('02/18/2005', 'MM/DD/YYYY'), 497.09);
Insert into T1 Values (TO_DATE('02/19/2005', 'MM/DD/YYYY'), 34.04);
Insert into T1 Values (TO_DATE('02/20/2005', 'MM/DD/YYYY'), 22.74);
Insert into T1 Values (TO_DATE('02/21/2005', 'MM/DD/YYYY'), 373.17);
Insert into T1 Values (TO_DATE('02/22/2005', 'MM/DD/YYYY'), 900.13);
Insert into T1 Values (TO_DATE('02/23/2005', 'MM/DD/YYYY'), 765.78);
Insert into T1 Values (TO_DATE('02/24/2005', 'MM/DD/YYYY'), 738.83);
Insert into T1 Values (TO_DATE('02/25/2005', 'MM/DD/YYYY'), 717.09);
Insert into T1 Values (TO_DATE('02/26/2005', 'MM/DD/YYYY'), 1233.61);
Insert into T1 Values (TO_DATE('02/27/2005', 'MM/DD/YYYY'), 12.74);
Insert into T1 Values (TO_DATE('02/28/2005', 'MM/DD/YYYY'), 916.65);
Insert into T1 Values (TO_DATE('03/01/2005', 'MM/DD/YYYY'), 626.22);
Insert into T1 Values (TO_DATE('03/02/2005', 'MM/DD/YYYY'), 628.83);
Insert into T1 Values (TO_DATE('03/03/2005', 'MM/DD/YYYY'), 1490.13);
Insert into T1 Values (TO_DATE('03/04/2005', 'MM/DD/YYYY'), 732.3);
Insert into T1 Values (TO_DATE('03/05/2005', 'MM/DD/YYYY'), 85.35);
Insert into T1 Values (TO_DATE('03/06/2005', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('03/07/2005', 'MM/DD/YYYY'), 842.74);
Insert into T1 Values (TO_DATE('03/08/2005', 'MM/DD/YYYY'), 844.48);
Insert into T1 Values (TO_DATE('03/09/2005', 'MM/DD/YYYY'), 1014.91);
Insert into T1 Values (TO_DATE('03/10/2005', 'MM/DD/YYYY'), 818.39);
Insert into T1 Values (TO_DATE('03/11/2005', 'MM/DD/YYYY'), 645.35);
Insert into T1 Values (TO_DATE('03/12/2005', 'MM/DD/YYYY'), 17.96);
Insert into T1 Values (TO_DATE('03/13/2005', 'MM/DD/YYYY'), 22.3);
Insert into T1 Values (TO_DATE('03/14/2005', 'MM/DD/YYYY'), 941);
Insert into T1 Values (TO_DATE('03/15/2005', 'MM/DD/YYYY'), 857.09);
Insert into T1 Values (TO_DATE('03/16/2005', 'MM/DD/YYYY'), 876.65);
Insert into T1 Values (TO_DATE('03/17/2005', 'MM/DD/YYYY'), 800.13);
Insert into T1 Values (TO_DATE('03/18/2005', 'MM/DD/YYYY'), 754.04);
Insert into T1 Values (TO_DATE('03/19/2005', 'MM/DD/YYYY'), 18.83);
Insert into T1 Values (TO_DATE('03/20/2005', 'MM/DD/YYYY'), 17.96);
Insert into T1 Values (TO_DATE('03/21/2005', 'MM/DD/YYYY'), 726.65);
Insert into T1 Values (TO_DATE('03/22/2005', 'MM/DD/YYYY'), 977.09);
Insert into T1 Values (TO_DATE('03/23/2005', 'MM/DD/YYYY'), 741);
Insert into T1 Values (TO_DATE('03/24/2005', 'MM/DD/YYYY'), 675.78);
Insert into T1 Values (TO_DATE('03/25/2005', 'MM/DD/YYYY'), 475.78);
Insert into T1 Values (TO_DATE('03/26/2005', 'MM/DD/YYYY'), 27.52);
Insert into T1 Values (TO_DATE('03/27/2005', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('03/28/2005', 'MM/DD/YYYY'), 711.87);
Insert into T1 Values (TO_DATE('03/29/2005', 'MM/DD/YYYY'), 2852.3);
Insert into T1 Values (TO_DATE('03/30/2005', 'MM/DD/YYYY'), 926.65);
Insert into T1 Values (TO_DATE('03/31/2005', 'MM/DD/YYYY'), 682.3);
Insert into T1 Values (TO_DATE('04/01/2005', 'MM/DD/YYYY'), 704.48);
Insert into T1 Values (TO_DATE('04/02/2005', 'MM/DD/YYYY'), 22.3);
Insert into T1 Values (TO_DATE('04/03/2005', 'MM/DD/YYYY'), 34.91);
Insert into T1 Values (TO_DATE('04/04/2005', 'MM/DD/YYYY'), 960.13);
Insert into T1 Values (TO_DATE('04/05/2005', 'MM/DD/YYYY'), 723.61);
Insert into T1 Values (TO_DATE('04/06/2005', 'MM/DD/YYYY'), 664.91);
Insert into T1 Values (TO_DATE('04/07/2005', 'MM/DD/YYYY'), 812.74);
Insert into T1 Values (TO_DATE('04/08/2005', 'MM/DD/YYYY'), 748.39);
Insert into T1 Values (TO_DATE('04/09/2005', 'MM/DD/YYYY'), 21.87);
Insert into T1 Values (TO_DATE('04/10/2005', 'MM/DD/YYYY'), 8.39);
Insert into T1 Values (TO_DATE('04/11/2005', 'MM/DD/YYYY'), 545.78);
Insert into T1 Values (TO_DATE('04/12/2005', 'MM/DD/YYYY'), 847.09);
Insert into T1 Values (TO_DATE('04/13/2005', 'MM/DD/YYYY'), 938.39);
Insert into T1 Values (TO_DATE('04/14/2005', 'MM/DD/YYYY'), 1174.91);
Insert into T1 Values (TO_DATE('04/15/2005', 'MM/DD/YYYY'), 641.43);
Insert into T1 Values (TO_DATE('04/16/2005', 'MM/DD/YYYY'), 397.96);
Insert into T1 Values (TO_DATE('04/17/2005', 'MM/DD/YYYY'), 2.3);
Insert into T1 Values (TO_DATE('04/18/2005', 'MM/DD/YYYY'), 1567.96);
Insert into T1 Values (TO_DATE('04/19/2005', 'MM/DD/YYYY'), 863.17);
Insert into T1 Values (TO_DATE('04/20/2005', 'MM/DD/YYYY'), 874.91);
Insert into T1 Values (TO_DATE('04/21/2005', 'MM/DD/YYYY'), 1702.74);
Insert into T1 Values (TO_DATE('04/22/2005', 'MM/DD/YYYY'), 1129.26);
Insert into T1 Values (TO_DATE('04/23/2005', 'MM/DD/YYYY'), 20.57);
Insert into T1 Values (TO_DATE('04/24/2005', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('04/25/2005', 'MM/DD/YYYY'), 742.3);
Insert into T1 Values (TO_DATE('04/26/2005', 'MM/DD/YYYY'), 791.87);
Insert into T1 Values (TO_DATE('04/27/2005', 'MM/DD/YYYY'), 823.61);
Insert into T1 Values (TO_DATE('04/28/2005', 'MM/DD/YYYY'), 734.48);
Insert into T1 Values (TO_DATE('04/29/2005', 'MM/DD/YYYY'), 864.48);
Insert into T1 Values (TO_DATE('04/30/2005', 'MM/DD/YYYY'), 23.61);
Insert into T1 Values (TO_DATE('05/01/2005', 'MM/DD/YYYY'), 4.91);
Insert into T1 Values (TO_DATE('05/02/2005', 'MM/DD/YYYY'), 714.91);
Insert into T1 Values (TO_DATE('05/03/2005', 'MM/DD/YYYY'), 991);
Insert into T1 Values (TO_DATE('05/04/2005', 'MM/DD/YYYY'), 693.17);
Insert into T1 Values (TO_DATE('05/05/2005', 'MM/DD/YYYY'), 645.35);
Insert into T1 Values (TO_DATE('05/06/2005', 'MM/DD/YYYY'), 608.83);
Insert into T1 Values (TO_DATE('05/07/2005', 'MM/DD/YYYY'), 30.57);
Insert into T1 Values (TO_DATE('05/08/2005', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('05/09/2005', 'MM/DD/YYYY'), 714.04);
Insert into T1 Values (TO_DATE('05/10/2005', 'MM/DD/YYYY'), 974.48);
Insert into T1 Values (TO_DATE('05/11/2005', 'MM/DD/YYYY'), 868.83);
Insert into T1 Values (TO_DATE('05/12/2005', 'MM/DD/YYYY'), 774.04);
Insert into T1 Values (TO_DATE('05/13/2005', 'MM/DD/YYYY'), 657.52);
Insert into T1 Values (TO_DATE('05/14/2005', 'MM/DD/YYYY'), 30.57);
Insert into T1 Values (TO_DATE('05/15/2005', 'MM/DD/YYYY'), 15.78);
Insert into T1 Values (TO_DATE('05/16/2005', 'MM/DD/YYYY'), 739.7);
Insert into T1 Values (TO_DATE('05/17/2005', 'MM/DD/YYYY'), 792.3);
Insert into T1 Values (TO_DATE('05/18/2005', 'MM/DD/YYYY'), 775.78);
Insert into T1 Values (TO_DATE('05/19/2005', 'MM/DD/YYYY'), 732.3);
Insert into T1 Values (TO_DATE('05/20/2005', 'MM/DD/YYYY'), 612.3);
Insert into T1 Values (TO_DATE('05/21/2005', 'MM/DD/YYYY'), 28.39);
Insert into T1 Values (TO_DATE('05/22/2005', 'MM/DD/YYYY'), 3.17);
Insert into T1 Values (TO_DATE('05/23/2005', 'MM/DD/YYYY'), 674.48);
Insert into T1 Values (TO_DATE('05/24/2005', 'MM/DD/YYYY'), 663.61);
Insert into T1 Values (TO_DATE('05/25/2005', 'MM/DD/YYYY'), 768.39);
Insert into T1 Values (TO_DATE('05/26/2005', 'MM/DD/YYYY'), 786.22);
Insert into T1 Values (TO_DATE('05/27/2005', 'MM/DD/YYYY'), 591);
Insert into T1 Values (TO_DATE('05/28/2005', 'MM/DD/YYYY'), 25.35);
Insert into T1 Values (TO_DATE('05/29/2005', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('05/30/2005', 'MM/DD/YYYY'), 1.43);
Insert into T1 Values (TO_DATE('05/31/2005', 'MM/DD/YYYY'), 672.74);
Insert into T1 Values (TO_DATE('06/01/2005', 'MM/DD/YYYY'), 831.43);
Insert into T1 Values (TO_DATE('06/02/2005', 'MM/DD/YYYY'), 757.52);
Insert into T1 Values (TO_DATE('06/03/2005', 'MM/DD/YYYY'), 740.57);
Insert into T1 Values (TO_DATE('06/04/2005', 'MM/DD/YYYY'), 31.87);
Insert into T1 Values (TO_DATE('06/05/2005', 'MM/DD/YYYY'), 13.61);
Insert into T1 Values (TO_DATE('06/06/2005', 'MM/DD/YYYY'), 7076.65);
Insert into T1 Values (TO_DATE('06/07/2005', 'MM/DD/YYYY'), 769.26);
Insert into T1 Values (TO_DATE('06/08/2005', 'MM/DD/YYYY'), 764.91);
Insert into T1 Values (TO_DATE('06/09/2005', 'MM/DD/YYYY'), 821);
Insert into T1 Values (TO_DATE('06/10/2005', 'MM/DD/YYYY'), 671.87);
Insert into T1 Values (TO_DATE('06/11/2005', 'MM/DD/YYYY'), 29.7);
Insert into T1 Values (TO_DATE('06/12/2005', 'MM/DD/YYYY'), 5.78);
Insert into T1 Values (TO_DATE('06/13/2005', 'MM/DD/YYYY'), 770.13);
Insert into T1 Values (TO_DATE('06/14/2005', 'MM/DD/YYYY'), 834.91);
Insert into T1 Values (TO_DATE('06/15/2005', 'MM/DD/YYYY'), 691.87);
Insert into T1 Values (TO_DATE('06/16/2005', 'MM/DD/YYYY'), 627.96);
Insert into T1 Values (TO_DATE('06/17/2005', 'MM/DD/YYYY'), 884.48);
Insert into T1 Values (TO_DATE('06/18/2005', 'MM/DD/YYYY'), 27.96);
Insert into T1 Values (TO_DATE('06/19/2005', 'MM/DD/YYYY'), 31.43);
Insert into T1 Values (TO_DATE('06/20/2005', 'MM/DD/YYYY'), 624.04);
Insert into T1 Values (TO_DATE('06/21/2005', 'MM/DD/YYYY'), 885.35);
Insert into T1 Values (TO_DATE('06/22/2005', 'MM/DD/YYYY'), 780.13);
Insert into T1 Values (TO_DATE('06/23/2005', 'MM/DD/YYYY'), 985.78);
Insert into T1 Values (TO_DATE('06/24/2005', 'MM/DD/YYYY'), 846.22);
Insert into T1 Values (TO_DATE('06/25/2005', 'MM/DD/YYYY'), 16.22);
Insert into T1 Values (TO_DATE('06/26/2005', 'MM/DD/YYYY'), 1.87);
Insert into T1 Values (TO_DATE('06/27/2005', 'MM/DD/YYYY'), 683.17);
Insert into T1 Values (TO_DATE('06/28/2005', 'MM/DD/YYYY'), 807.09);
Insert into T1 Values (TO_DATE('06/29/2005', 'MM/DD/YYYY'), 656.22);
Insert into T1 Values (TO_DATE('06/30/2005', 'MM/DD/YYYY'), 1157.52);
Insert into T1 Values (TO_DATE('07/01/2005', 'MM/DD/YYYY'), 485.78);
Insert into T1 Values (TO_DATE('07/02/2005', 'MM/DD/YYYY'), 16.65);
Insert into T1 Values (TO_DATE('07/03/2005', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('07/04/2005', 'MM/DD/YYYY'), 6.22);
Insert into T1 Values (TO_DATE('07/05/2005', 'MM/DD/YYYY'), 804.04);
Insert into T1 Values (TO_DATE('07/06/2005', 'MM/DD/YYYY'), 723.61);
Insert into T1 Values (TO_DATE('07/07/2005', 'MM/DD/YYYY'), 807.09);
Insert into T1 Values (TO_DATE('07/08/2005', 'MM/DD/YYYY'), 657.96);
Insert into T1 Values (TO_DATE('07/09/2005', 'MM/DD/YYYY'), 52.74);
Insert into T1 Values (TO_DATE('07/10/2005', 'MM/DD/YYYY'), 11.87);
Insert into T1 Values (TO_DATE('07/11/2005', 'MM/DD/YYYY'), 2854.48);
Insert into T1 Values (TO_DATE('07/12/2005', 'MM/DD/YYYY'), 734.48);
Insert into T1 Values (TO_DATE('07/13/2005', 'MM/DD/YYYY'), 712.74);
Insert into T1 Values (TO_DATE('07/14/2005', 'MM/DD/YYYY'), 711.43);
Insert into T1 Values (TO_DATE('07/15/2005', 'MM/DD/YYYY'), 695.78);
Insert into T1 Values (TO_DATE('07/16/2005', 'MM/DD/YYYY'), 49.7);
Insert into T1 Values (TO_DATE('07/17/2005', 'MM/DD/YYYY'), 22.74);
Insert into T1 Values (TO_DATE('07/18/2005', 'MM/DD/YYYY'), 589.7);
Insert into T1 Values (TO_DATE('07/19/2005', 'MM/DD/YYYY'), 865.35);
Insert into T1 Values (TO_DATE('07/20/2005', 'MM/DD/YYYY'), 897.96);
Insert into T1 Values (TO_DATE('07/21/2005', 'MM/DD/YYYY'), 666.65);
Insert into T1 Values (TO_DATE('07/22/2005', 'MM/DD/YYYY'), 637.96);
Insert into T1 Values (TO_DATE('07/23/2005', 'MM/DD/YYYY'), 79.26);
Insert into T1 Values (TO_DATE('07/24/2005', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('07/25/2005', 'MM/DD/YYYY'), 736.22);
Insert into T1 Values (TO_DATE('07/26/2005', 'MM/DD/YYYY'), 674.91);
Insert into T1 Values (TO_DATE('07/27/2005', 'MM/DD/YYYY'), 689.7);
Insert into T1 Values (TO_DATE('07/28/2005', 'MM/DD/YYYY'), 621.43);
Insert into T1 Values (TO_DATE('07/29/2005', 'MM/DD/YYYY'), 579.26);
Insert into T1 Values (TO_DATE('07/30/2005', 'MM/DD/YYYY'), 19.7);
Insert into T1 Values (TO_DATE('07/31/2005', 'MM/DD/YYYY'), 7.09);
Insert into T1 Values (TO_DATE('08/01/2005', 'MM/DD/YYYY'), 655.78);
Insert into T1 Values (TO_DATE('08/02/2005', 'MM/DD/YYYY'), 966.22);
Insert into T1 Values (TO_DATE('08/03/2005', 'MM/DD/YYYY'), 701);
Insert into T1 Values (TO_DATE('08/04/2005', 'MM/DD/YYYY'), 806.65);
Insert into T1 Values (TO_DATE('08/05/2005', 'MM/DD/YYYY'), 643.17);
Insert into T1 Values (TO_DATE('08/06/2005', 'MM/DD/YYYY'), 53.17);
Insert into T1 Values (TO_DATE('08/07/2005', 'MM/DD/YYYY'), 7.09);
Insert into T1 Values (TO_DATE('08/08/2005', 'MM/DD/YYYY'), 881);
Insert into T1 Values (TO_DATE('08/09/2005', 'MM/DD/YYYY'), 774.91);
Insert into T1 Values (TO_DATE('08/10/2005', 'MM/DD/YYYY'), 796.65);
Insert into T1 Values (TO_DATE('08/11/2005', 'MM/DD/YYYY'), 961.43);
Insert into T1 Values (TO_DATE('08/12/2005', 'MM/DD/YYYY'), 702.3);
Insert into T1 Values (TO_DATE('08/13/2005', 'MM/DD/YYYY'), 131.43);
Insert into T1 Values (TO_DATE('08/14/2005', 'MM/DD/YYYY'), 4.04);
Insert into T1 Values (TO_DATE('08/15/2005', 'MM/DD/YYYY'), 828.39);
Insert into T1 Values (TO_DATE('08/16/2005', 'MM/DD/YYYY'), 862.3);
Insert into T1 Values (TO_DATE('08/17/2005', 'MM/DD/YYYY'), 880.13);
Insert into T1 Values (TO_DATE('08/18/2005', 'MM/DD/YYYY'), 755.35);
Insert into T1 Values (TO_DATE('08/19/2005', 'MM/DD/YYYY'), 414.48);
Insert into T1 Values (TO_DATE('08/20/2005', 'MM/DD/YYYY'), 13.17);
Insert into T1 Values (TO_DATE('08/21/2005', 'MM/DD/YYYY'), 27.52);
Insert into T1 Values (TO_DATE('08/22/2005', 'MM/DD/YYYY'), 435.35);
Insert into T1 Values (TO_DATE('08/23/2005', 'MM/DD/YYYY'), 1400.57);
Insert into T1 Values (TO_DATE('08/24/2005', 'MM/DD/YYYY'), 823.17);
Insert into T1 Values (TO_DATE('08/25/2005', 'MM/DD/YYYY'), 901.43);
Insert into T1 Values (TO_DATE('08/26/2005', 'MM/DD/YYYY'), 748.39);
Insert into T1 Values (TO_DATE('08/27/2005', 'MM/DD/YYYY'), 51);
Insert into T1 Values (TO_DATE('08/28/2005', 'MM/DD/YYYY'), 20.57);
Insert into T1 Values (TO_DATE('08/29/2005', 'MM/DD/YYYY'), 664.91);
Insert into T1 Values (TO_DATE('08/30/2005', 'MM/DD/YYYY'), 797.96);
Insert into T1 Values (TO_DATE('08/31/2005', 'MM/DD/YYYY'), 706.22);
Insert into T1 Values (TO_DATE('09/01/2005', 'MM/DD/YYYY'), 612.74);
Insert into T1 Values (TO_DATE('09/02/2005', 'MM/DD/YYYY'), 617.96);
Insert into T1 Values (TO_DATE('09/03/2005', 'MM/DD/YYYY'), 37.52);
Insert into T1 Values (TO_DATE('09/04/2005', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('09/05/2005', 'MM/DD/YYYY'), 4.04);
Insert into T1 Values (TO_DATE('09/06/2005', 'MM/DD/YYYY'), 974.91);
Insert into T1 Values (TO_DATE('09/07/2005', 'MM/DD/YYYY'), 1003.17);
Insert into T1 Values (TO_DATE('09/08/2005', 'MM/DD/YYYY'), 686.65);
Insert into T1 Values (TO_DATE('09/09/2005', 'MM/DD/YYYY'), 843.17);
Insert into T1 Values (TO_DATE('09/10/2005', 'MM/DD/YYYY'), 24.04);
Insert into T1 Values (TO_DATE('09/11/2005', 'MM/DD/YYYY'), 8.83);
Insert into T1 Values (TO_DATE('09/12/2005', 'MM/DD/YYYY'), 771.43);
Insert into T1 Values (TO_DATE('09/13/2005', 'MM/DD/YYYY'), 797.52);
Insert into T1 Values (TO_DATE('09/14/2005', 'MM/DD/YYYY'), 775.78);
Insert into T1 Values (TO_DATE('09/15/2005', 'MM/DD/YYYY'), 829.26);
Insert into T1 Values (TO_DATE('09/16/2005', 'MM/DD/YYYY'), 715.78);
Insert into T1 Values (TO_DATE('09/17/2005', 'MM/DD/YYYY'), 57.09);
Insert into T1 Values (TO_DATE('09/18/2005', 'MM/DD/YYYY'), 11.87);
Insert into T1 Values (TO_DATE('09/19/2005', 'MM/DD/YYYY'), 850.57);
Insert into T1 Values (TO_DATE('09/20/2005', 'MM/DD/YYYY'), 820.57);
Insert into T1 Values (TO_DATE('09/21/2005', 'MM/DD/YYYY'), 851.87);
Insert into T1 Values (TO_DATE('09/22/2005', 'MM/DD/YYYY'), 694.48);
Insert into T1 Values (TO_DATE('09/23/2005', 'MM/DD/YYYY'), 758.83);
Insert into T1 Values (TO_DATE('09/24/2005', 'MM/DD/YYYY'), 20.57);
Insert into T1 Values (TO_DATE('09/25/2005', 'MM/DD/YYYY'), 20.57);
Insert into T1 Values (TO_DATE('09/26/2005', 'MM/DD/YYYY'), 727.09);
Insert into T1 Values (TO_DATE('09/27/2005', 'MM/DD/YYYY'), 966.65);
Insert into T1 Values (TO_DATE('09/28/2005', 'MM/DD/YYYY'), 770.13);
Insert into T1 Values (TO_DATE('09/29/2005', 'MM/DD/YYYY'), 843.61);
Insert into T1 Values (TO_DATE('09/30/2005', 'MM/DD/YYYY'), 710.13);
Insert into T1 Values (TO_DATE('10/01/2005', 'MM/DD/YYYY'), 26.65);
Insert into T1 Values (TO_DATE('10/02/2005', 'MM/DD/YYYY'), 22.3);
Insert into T1 Values (TO_DATE('10/03/2005', 'MM/DD/YYYY'), 822.74);
Insert into T1 Values (TO_DATE('10/04/2005', 'MM/DD/YYYY'), 639.26);
Insert into T1 Values (TO_DATE('10/05/2005', 'MM/DD/YYYY'), 866.22);
Insert into T1 Values (TO_DATE('10/06/2005', 'MM/DD/YYYY'), 833.61);
Insert into T1 Values (TO_DATE('10/07/2005', 'MM/DD/YYYY'), 704.91);
Insert into T1 Values (TO_DATE('10/08/2005', 'MM/DD/YYYY'), 21.43);
Insert into T1 Values (TO_DATE('10/09/2005', 'MM/DD/YYYY'), 11);
Insert into T1 Values (TO_DATE('10/10/2005', 'MM/DD/YYYY'), 661.87);
Insert into T1 Values (TO_DATE('10/11/2005', 'MM/DD/YYYY'), 762.74);
Insert into T1 Values (TO_DATE('10/12/2005', 'MM/DD/YYYY'), 840.13);
Insert into T1 Values (TO_DATE('10/13/2005', 'MM/DD/YYYY'), 696.65);
Insert into T1 Values (TO_DATE('10/14/2005', 'MM/DD/YYYY'), 702.74);
Insert into T1 Values (TO_DATE('10/15/2005', 'MM/DD/YYYY'), 75.35);
Insert into T1 Values (TO_DATE('10/16/2005', 'MM/DD/YYYY'), 4.48);
Insert into T1 Values (TO_DATE('10/17/2005', 'MM/DD/YYYY'), 793.61);
Insert into T1 Values (TO_DATE('10/18/2005', 'MM/DD/YYYY'), 607.52);
Insert into T1 Values (TO_DATE('10/19/2005', 'MM/DD/YYYY'), 682.74);
Insert into T1 Values (TO_DATE('10/20/2005', 'MM/DD/YYYY'), 650.13);
Insert into T1 Values (TO_DATE('10/21/2005', 'MM/DD/YYYY'), 1561);
Insert into T1 Values (TO_DATE('10/22/2005', 'MM/DD/YYYY'), 43.61);
Insert into T1 Values (TO_DATE('10/23/2005', 'MM/DD/YYYY'), 11.43);
Insert into T1 Values (TO_DATE('10/24/2005', 'MM/DD/YYYY'), 721);
Insert into T1 Values (TO_DATE('10/25/2005', 'MM/DD/YYYY'), 904.91);
Insert into T1 Values (TO_DATE('10/26/2005', 'MM/DD/YYYY'), 961);
Insert into T1 Values (TO_DATE('10/27/2005', 'MM/DD/YYYY'), 830.57);
Insert into T1 Values (TO_DATE('10/28/2005', 'MM/DD/YYYY'), 696.22);
Insert into T1 Values (TO_DATE('10/29/2005', 'MM/DD/YYYY'), 45.35);
Insert into T1 Values (TO_DATE('10/30/2005', 'MM/DD/YYYY'), 13.61);
Insert into T1 Values (TO_DATE('10/31/2005', 'MM/DD/YYYY'), 698.83);
Insert into T1 Values (TO_DATE('11/01/2005', 'MM/DD/YYYY'), 738.39);
Insert into T1 Values (TO_DATE('11/02/2005', 'MM/DD/YYYY'), 1079.26);
Insert into T1 Values (TO_DATE('11/03/2005', 'MM/DD/YYYY'), 784.91);
Insert into T1 Values (TO_DATE('11/04/2005', 'MM/DD/YYYY'), 957.96);
Insert into T1 Values (TO_DATE('11/05/2005', 'MM/DD/YYYY'), 57.52);
Insert into T1 Values (TO_DATE('11/06/2005', 'MM/DD/YYYY'), 5.35);
Insert into T1 Values (TO_DATE('11/07/2005', 'MM/DD/YYYY'), 659.26);
Insert into T1 Values (TO_DATE('11/08/2005', 'MM/DD/YYYY'), 1039.7);
Insert into T1 Values (TO_DATE('11/09/2005', 'MM/DD/YYYY'), 962.74);
Insert into T1 Values (TO_DATE('11/10/2005', 'MM/DD/YYYY'), 792.3);
Insert into T1 Values (TO_DATE('11/11/2005', 'MM/DD/YYYY'), 731);
Insert into T1 Values (TO_DATE('11/12/2005', 'MM/DD/YYYY'), 57.09);
Insert into T1 Values (TO_DATE('11/13/2005', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('11/14/2005', 'MM/DD/YYYY'), 761.87);
Insert into T1 Values (TO_DATE('11/15/2005', 'MM/DD/YYYY'), 838.83);
Insert into T1 Values (TO_DATE('11/16/2005', 'MM/DD/YYYY'), 804.48);
Insert into T1 Values (TO_DATE('11/17/2005', 'MM/DD/YYYY'), 1022.3);
Insert into T1 Values (TO_DATE('11/18/2005', 'MM/DD/YYYY'), 997.96);
Insert into T1 Values (TO_DATE('11/19/2005', 'MM/DD/YYYY'), 13.61);
Insert into T1 Values (TO_DATE('11/20/2005', 'MM/DD/YYYY'), 3.61);
Insert into T1 Values (TO_DATE('11/21/2005', 'MM/DD/YYYY'), 1044.48);
Insert into T1 Values (TO_DATE('11/22/2005', 'MM/DD/YYYY'), 865.35);
Insert into T1 Values (TO_DATE('11/23/2005', 'MM/DD/YYYY'), 578.83);
Insert into T1 Values (TO_DATE('11/24/2005', 'MM/DD/YYYY'), 18.83);
Insert into T1 Values (TO_DATE('11/25/2005', 'MM/DD/YYYY'), 124.04);
Insert into T1 Values (TO_DATE('11/26/2005', 'MM/DD/YYYY'), 6.22);
Insert into T1 Values (TO_DATE('11/27/2005', 'MM/DD/YYYY'), 17.52);
Insert into T1 Values (TO_DATE('11/28/2005', 'MM/DD/YYYY'), 977.96);
Insert into T1 Values (TO_DATE('11/29/2005', 'MM/DD/YYYY'), 854.48);
Insert into T1 Values (TO_DATE('11/30/2005', 'MM/DD/YYYY'), 840.57);
Insert into T1 Values (TO_DATE('12/01/2005', 'MM/DD/YYYY'), 684.48);
Insert into T1 Values (TO_DATE('12/02/2005', 'MM/DD/YYYY'), 694.48);
Insert into T1 Values (TO_DATE('12/03/2005', 'MM/DD/YYYY'), 40.57);
Insert into T1 Values (TO_DATE('12/04/2005', 'MM/DD/YYYY'), 37.96);
Insert into T1 Values (TO_DATE('12/05/2005', 'MM/DD/YYYY'), 657.52);
Insert into T1 Values (TO_DATE('12/06/2005', 'MM/DD/YYYY'), 971.43);
Insert into T1 Values (TO_DATE('12/07/2005', 'MM/DD/YYYY'), 872.3);
Insert into T1 Values (TO_DATE('12/08/2005', 'MM/DD/YYYY'), 912.74);
Insert into T1 Values (TO_DATE('12/09/2005', 'MM/DD/YYYY'), 690.13);
Insert into T1 Values (TO_DATE('12/10/2005', 'MM/DD/YYYY'), 14.04);
Insert into T1 Values (TO_DATE('12/11/2005', 'MM/DD/YYYY'), 6.22);
Insert into T1 Values (TO_DATE('12/12/2005', 'MM/DD/YYYY'), 580.13);
Insert into T1 Values (TO_DATE('12/13/2005', 'MM/DD/YYYY'), 1003.17);
Insert into T1 Values (TO_DATE('12/14/2005', 'MM/DD/YYYY'), 638.83);
Insert into T1 Values (TO_DATE('12/15/2005', 'MM/DD/YYYY'), 999.7);
Insert into T1 Values (TO_DATE('12/16/2005', 'MM/DD/YYYY'), 795.78);
Insert into T1 Values (TO_DATE('12/17/2005', 'MM/DD/YYYY'), 17.09);
Insert into T1 Values (TO_DATE('12/18/2005', 'MM/DD/YYYY'), 6.65);
Insert into T1 Values (TO_DATE('12/19/2005', 'MM/DD/YYYY'), 760.13);
Insert into T1 Values (TO_DATE('12/20/2005', 'MM/DD/YYYY'), 881.87);
Insert into T1 Values (TO_DATE('12/21/2005', 'MM/DD/YYYY'), 1015.78);
Insert into T1 Values (TO_DATE('12/22/2005', 'MM/DD/YYYY'), 899.7);
Insert into T1 Values (TO_DATE('12/23/2005', 'MM/DD/YYYY'), 823.61);
Insert into T1 Values (TO_DATE('12/24/2005', 'MM/DD/YYYY'), 7.96);
Insert into T1 Values (TO_DATE('12/26/2005', 'MM/DD/YYYY'), 10.13);
Insert into T1 Values (TO_DATE('12/27/2005', 'MM/DD/YYYY'), 694.48);
Insert into T1 Values (TO_DATE('12/28/2005', 'MM/DD/YYYY'), 744.48);
Insert into T1 Values (TO_DATE('12/29/2005', 'MM/DD/YYYY'), 1321.43);
Insert into T1 Values (TO_DATE('12/30/2005', 'MM/DD/YYYY'), 1052.74);
Insert into T1 Values (TO_DATE('12/31/2005', 'MM/DD/YYYY'), 11.43);
COMMIT;

Hi Tom,
I did try to attempt the query but this is not what I wanted.
What I want is the 10 day range across years but day and month same. Its like a seasonal fator.
for e.g for 7 out of 10 years ( 1995 to 2005 ) every year between Feb 2 to Feb 12 had the best growth % along with atleast 70% ( i.e. 7 out of 10 years ) the growth rate was positive during this time period.

Please help.

select lag(dt,9) over (order by dt) startdate, dt enddate,
(nsales - nsales9)/nsales9 * 100 growth,
decode( sign(lag(nsales,8) over (order by dt)-lag(nsales,9) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,7) over (order by dt)-lag(nsales,8) over (order by dt)),
1, 1,0 )+
decode( sign(lag(nsales,6) over (order by dt)-lag(nsales,7) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,5) over (order by dt)-lag(nsales,6) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,4) over (order by dt)-lag(nsales,5) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,3) over (order by dt)-lag(nsales,4) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,2) over (order by dt)-lag(nsales,3) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,1) over (order by dt)-lag(nsales,2) over (order by dt)),
1, 1,0 ) +
decode( sign(lag(nsales,0) over (order by dt)-lag(nsales,1) over (order by dt)),
1, 1,0 )
percentage
from (
select dt, nsales,
lag(nsales,1) over (order by dt) nsales1,
lag(nsales,2) over (order by dt) nsales2,
lag(nsales,3) over (order by dt) nsales3,
lag(nsales,4) over (order by dt) nsales4,
lag(nsales,5) over (order by dt) nsales5,
lag(nsales,6) over (order by dt) nsales6,
lag(nsales,7) over (order by dt) nsales7,
lag(nsales,8) over (order by dt) nsales8,
lag(nsales,9) over (order by dt) nsales9
from T1
) T

Tom,
I came across an article "The Impact of the OLAP/OLTP Cultural Conflict on Data Warehousing"

Iam pasting only some part of the article.

<<
This article examines the differences between data warehousing&#8217;s &#8220;old mindset&#8221; (OLTP) and the &#8220;new mindset&#8221; (OLAP) for building data warehouses. It explains in particular why applying OLTP procedures to OLAP activities is an almost certain prescription for failure. It describes why OLAP procedures are a requirement for a successful data warehouse implementation, and suggests how to assist the OLTP community with adapting to OLAP culture &#8211; at least enough to get data warehouses up and running until they acquire a life of their own.

Several years ago an instructor in a class on data warehousing told his students that a new mindset is required to successfully build a data warehouse. He compared the then-nescient data warehousing technology to the early days of television when there were only former radio executives with their old, non-visual mindset available to work in the new medium. The resulting programs were somewhat stilted and constrained, not particularly entertaining, and certainly did not exploit the new medium&#8217;s full potential.

The analogous &#8220;old mindset&#8221; in data warehousing to which the instructor was referring is online transaction processing, or OLTP. It refers to the technology that underlies the overwhelming majority of contemporary administrative data processing systems &#8211; human resources, financial accounting, and, in higher education, student records. It stands for tightly controlled, hierarchical implementation and maintenance regimes with heavy dependence on schedules, milestones, deadlines, and enormous amounts of detailed planning.

The required &#8220;new mindset&#8221; is called online analytical processing, or OLAP, and it embodies a much less structured &#8211; some would say iterative &#8211; approach. It is the imprimatur for the relatively new field of information access for strategic and managerial purposes and for operational purposes as well. The terms OLTP and OLAP have come to symbolize different and highly distinctive data processing cultures currently in some degree of conflict. This cultural conflict has a negative impact on data warehouse development with many users dismayed over the paucity of results after their own lengthy participation in requirements development and planning.

Summary
Applying OLTP procedures to an OLAP process is an almost-sure prescription for failure. One way to distinguish whether a proposed project is OLAP or OLTP is to assess the extent to which it will yield to planning. If the issue can be effectively addressed by significant advance detailed planning, it is probably an OLTP project. For example, a goal frequently considered by organizations contemplating the construction of a data warehouse is moving all production reporting to the data warehouse. A related objective often is to develop a set of parameterized canned reports that is made available to users over the Web. These objectives will yield to requirements analysis and a detailed plan for developing the required queries, and as such are essentially OLTP activities. The underlying activity of developing an effective, stable, and robust data model that will meet these requirements in addition to unplanned ad hoc queries requires experimentation-iteration, if you will &#8211; and thus remains an OLAP activity. The cultural conflict begins to assert itself when practitioners attempt to apply OLTP procedures to the OLAP model development process, in effect letting the tail wag the dog. The results seem to leave no one happy.

>>

After reading this article I was thinking how can anyone distinguish whether a given requirement needs an OLTP approach or an OLAP approach. Can you list down some points which you feel should be the deciding factor.

Hello,
You did answer my previous question regarding OLTP v/s OLAP. Appreciate if you can respond.

Thanks

Hello,
You did not answer my previous question regarding OLTP v/s OLAP. Appreciate if you
can respond.

Thanks
Aarti

Hello Tom,

Could you please tell me what kind of benefits we can gain creating dimensions using "CREATE DIMENSION ".I could not find any material related to this .Such as benefits of using this statement.

Could you pleae guid me

Thanks