I want to put the end result of a piece of data were collected from each data table on the table, so that I can direct export, otherwise every time each form a download again to EXCEL, very troublesome,

Problem as shown:

CodePudding user response:

Do you want to form the value of the column has merged together, if we can see user_tab_cols, value, if there is no relationship, these tables that how the table to the

CodePudding user response:

reference 1st floor yoyohey response:

do you want to form the value of the column has merged together, if we can see user_tab_cols, value, if there is no relationship, these tables that how big the table the

is to incorporate the columns of every single table into a table, just like my picture show, these tables are no relationship, I just want to have more than one table together to reduce my workload

CodePudding user response:

Table 1
1 row 2 column 3
1 2 3

Table 2 column 11 12 row 13
A b c


Table 1 table 2 results 1
1 row 11
Column 2 column 12
Columns and three columns 13


Results 2 column column 1 2 3 columns 11 12 row 13
1, 2, 3, a b c
What kind of effect?

CodePudding user response:

The

reference 3 floor yoyohey response:

table 1

1 row 2 column 3
1 2 3

Table 2 column 11 12 row 13
A b c


Table 1 table 2 results 1
1 row 11
Column 2 column 12
Columns and three columns 13


Results 2 column column 1 2 3 columns 11 12 row 13
1, 2, 3, a b c
What kind of effect?

the second effect

CodePudding user response:

Using rownum full join

CodePudding user response:

No relationship, can't ah

CodePudding user response:

With a as (select rownum as rn1,
T. *
The from Scott. Emp t),
B the as (select rownum as rn2,
T. *
The from Scott. Dept t)
Select a. *, b. *
From a
Full join b
On a.r n1=b.r n2

CodePudding user response:

Query out directly, the client tools is used to derive the line

CodePudding user response:

The

reference 7 floor yoyohey response:

with a as (select rownum as rn1,
T. *
The from Scott. Emp t),
B the as (select rownum as rn2,
T. *
The from Scott. Dept t)
Select a. *, b. *
From a
Full join b
On a.r n1=b.r n2

thanks brother!!!!! To solve!

CodePudding user response:

reference 5 floor nayi_224 reply:

full using rownum join

thank you