Oracle Tables with many columns
Posted: Wed Mar 05, 2014 3:41 pm
Hi,
Sorry if this is a repetitive post, I have searched and couldn't find any thing.
I have a situation where I am extracting data from Oracle table with more than 200 columns and loading into an another Oracle table with same structure. I need to select all the columns. I have to do some transformation before loaind the data. I am facing an issue in defining more than 200 columns in SELECT Quey as well as INSERT Query (the column definition in Oracle Conector Stage). Is there any way:
> to define the columns in a better and faster way
> Can I use SELECT * function to select all the columns and dynamically define the columns in the table?
Thanks
Yugee.
Sorry if this is a repetitive post, I have searched and couldn't find any thing.
I have a situation where I am extracting data from Oracle table with more than 200 columns and loading into an another Oracle table with same structure. I need to select all the columns. I have to do some transformation before loaind the data. I am facing an issue in defining more than 200 columns in SELECT Quey as well as INSERT Query (the column definition in Oracle Conector Stage). Is there any way:
> to define the columns in a better and faster way
> Can I use SELECT * function to select all the columns and dynamically define the columns in the table?
Thanks
Yugee.