Home » SQL & PL/SQL » SQL & PL/SQL » Help me problem with metadata and columns
Help me problem with metadata and columns [message #36509] Sat, 01 December 2001 07:46 Go to next message
Angelo
Messages: 16
Registered: November 2001
Junior Member
Hi ALL,

I have a fact table that has 30 columns and i have to obtain another table that has 7 columns.
In order to obtain the table with 7 columns i have a relationship among 30 Columns of the Fact table and the 7 columns of the other table.
For example if the first table has five columns (A,B,C,D,E) I have obtain another Table with two columns (X=A+C+D,Y=B+E) making the sum for each rows.

Do you have some idea in order to solve this problem?



----------------------------------------------------------------------

Report message to a moderator

Re: Help me problem with metadata and columns [message #36521 is a reply to message #36509] Sun, 02 December 2001 23:39 Go to previous message
tinel
Messages: 42
Registered: November 2001
Member
use the following:
create table child_table as (select a+c+d first_column_name, b+e second_column_name from parent table);

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Re: how use the if condition to check inputs in pl sql
Next Topic: How delete in cascade the records in the tables when they are in relationship
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 22 07:26:21 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.