If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Connecting 2 tables...

Hi

Running Oracle 9i.

I have a table1 which I've been loading data into for the last 6 months. The requirement now is to load all that data into another table2.

Is there a way that the data in table 1 can appear as if it exists in table 2 (only or too)? or something? because I can start loading data into table2 but I also need the last 6 months data (from table2).

Basically, I have some reports containing KPIs (which have formulas) which are created from some views which in turn are created from schema a.table a.

Now there was some new data (counters) which I started loading into schema b. table b.

Now I need to add some more KPIs to this report (making formulas using the counters in schema a. table a). But the query of the report is already showing KPIs (formulas created using counters from schemab. tableb.)

Because at the end of the day, I need to select the counters available in NUCELLREL from the CELLSTATS table (somehow).

NUCELLREL

datetime, bsc, cell, counter1, counter2, counter3.

CELLSTATS
datetime, bsc, cell, counter4, counter5, counter6

Silly question is:
Any way to do select counter1, counter2, counter3 from CELLSTATS?

Silly answer: generally no way. How would you relate them, if counter1 would be number of calls abroad and counter4 number of calls to the same network?

Anyway, there is a possibility that counters are in some relationship. It is data specific, so only the analyst (= the person who took user requirements and designed tables) should be able to tell this. It has nothing to do with Oracle (the way data is stored). Maybe you should ask him/her directly.