Re: turn column in table1 to the row in table2
> I'm trying to turn the one specific column from table1 into a row in my new table "Table2"
You can get a list of colA values from tblA with ...
select group_concat(colA) from tblA;
You could then massage that output string into an Insert statement for another table.
But why do this? What problem would it solve?
Subject
Written By
Posted
February 05, 2015 11:21AM
Re: turn column in table1 to the row in table2
February 05, 2015 12:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.