thank a lot

Thank all of you, I am just a new kid on the block

ok Dev thanks any way

well this morning I am trying on pretty similar thing but with no success. take a look at this

CREATE TABLE COURSE

(

CID ...

thanks Dev!

no the table name is actually called "fact_table". the idea is to insert td1id and td2id into the "fact_table.

create table test1 (t1id number (pk), t1name varchar2(5), t1job varchar2(20));

insert into test1 values (10, 'Paul', 'Driver');

insert into test1 values (11, smith', 'Chef');

insert into test1 values (13, 'andy', 'police');

create table test2...

I understand the concept but I am having problem with the implimentation. that said all that you have said have done with clear understanding.

thank for the tips, I am new in this field

sql developer in fact I just copy the syntax, i know that the quataion marks are not allow

so how can I populate the fact table

got your point

ok let put it this way, I will change the name of the table

:alien:

just name them like to differentiate the tables, in reality the name convention are different

so far I have created the table base on your advice, and my time table looks likes this:

CREATE TABLE "DIM_TIME"

(

"TIME_KEY" NUMBER,

...