set feedback off
set define off
prompt Creating MY_BUDGET_VERSIONS...
create table MY_BUDGET_VERSIONS
(
  BUDGET_VERSION_ID NUMBER,
  PROJECT_ID        NUMBER,
  BUDGET_TYPE       VARCHAR2(10),
  BASELINED_DATE    DATE,
  REVENUE           NUMBER
)
;

prompt Creating MY_PROJECTS...
create table MY_PROJECTS
(
  PROJECT_ID   NUMBER,
  PROJECT_NAME VARCHAR2(20)
)
;

prompt Creating MY_TIME_DIM...
create table MY_TIME_DIM
(
  DAY_DATE    DATE,
  YEAR        NUMBER,
  MONTH       NUMBER,
  DESCRIPTION VARCHAR2(20)
)
;

prompt Loading MY_BUDGET_VERSIONS...
insert into MY_BUDGET_VERSIONS (BUDGET_VERSION_ID, PROJECT_ID, BUDGET_TYPE, BASELINED_DATE, REVENUE)
values (1, 1, 'AR', to_date('02-01-2008 11:00:00', 'dd-mm-yyyy hh24:mi:ss'), 150);
insert into MY_BUDGET_VERSIONS (BUDGET_VERSION_ID, PROJECT_ID, BUDGET_TYPE, BASELINED_DATE, REVENUE)
values (2, 1, 'AR', to_date('04-01-2008 11:00:00', 'dd-mm-yyyy hh24:mi:ss'), 180);
insert into MY_BUDGET_VERSIONS (BUDGET_VERSION_ID, PROJECT_ID, BUDGET_TYPE, BASELINED_DATE, REVENUE)
values (3, 1, 'AR', to_date('04-01-2008 15:00:00', 'dd-mm-yyyy hh24:mi:ss'), 220);
insert into MY_BUDGET_VERSIONS (BUDGET_VERSION_ID, PROJECT_ID, BUDGET_TYPE, BASELINED_DATE, REVENUE)
values (4, 1, 'FR', to_date('01-01-2008 12:00:00', 'dd-mm-yyyy hh24:mi:ss'), 200);
insert into MY_BUDGET_VERSIONS (BUDGET_VERSION_ID, PROJECT_ID, BUDGET_TYPE, BASELINED_DATE, REVENUE)
values (5, 2, 'AR', to_date('15-12-2007 11:00:00', 'dd-mm-yyyy hh24:mi:ss'), 300);
insert into MY_BUDGET_VERSIONS (BUDGET_VERSION_ID, PROJECT_ID, BUDGET_TYPE, BASELINED_DATE, REVENUE)
values (6, 2, 'AR', to_date('03-01-2008 11:00:00', 'dd-mm-yyyy hh24:mi:ss'), 320);
commit;
prompt 6 records loaded
prompt Loading MY_PROJECTS...
insert into MY_PROJECTS (PROJECT_ID, PROJECT_NAME)
values (1, 'My project');
insert into MY_PROJECTS (PROJECT_ID, PROJECT_NAME)
values (2, 'Your project');
commit;
prompt 2 records loaded
prompt Loading MY_TIME_DIM...
insert into MY_TIME_DIM (DAY_DATE, YEAR, MONTH, DESCRIPTION)
values (to_date('01-01-2008', 'dd-mm-yyyy'), 2008, 1, '1 januari 2008');
insert into MY_TIME_DIM (DAY_DATE, YEAR, MONTH, DESCRIPTION)
values (to_date('02-01-2008', 'dd-mm-yyyy'), 2008, 1, '2 januari 2008');
insert into MY_TIME_DIM (DAY_DATE, YEAR, MONTH, DESCRIPTION)
values (to_date('03-01-2008', 'dd-mm-yyyy'), 2008, 1, '3 januari 2008');
insert into MY_TIME_DIM (DAY_DATE, YEAR, MONTH, DESCRIPTION)
values (to_date('04-01-2008', 'dd-mm-yyyy'), 2008, 1, '4 januari 2008');
insert into MY_TIME_DIM (DAY_DATE, YEAR, MONTH, DESCRIPTION)
values (to_date('05-01-2008', 'dd-mm-yyyy'), 2008, 1, '5 januari 2008');
insert into MY_TIME_DIM (DAY_DATE, YEAR, MONTH, DESCRIPTION)
values (to_date('06-01-2008', 'dd-mm-yyyy'), 2008, 1, '6 januari 2008');
commit;
prompt 6 records loaded
set feedback on
set define on
prompt Done.