Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 9, 2013 11:34 AM by
Create New Fields in Stage or Target Table
Jan 9, 2013 11:34 AM
Hello, I would like to ask how can I create some new fields in my table and fill them with some of my source data using a SQL expression.
My source data tables are under ODBC Module and I have created a staging table under the Oracle Module to load my source data.
I wonder whether I should create the extra fields in the staging table or in the target table and how do I fill them using SQL.
I am a bit amateur and trying to learn. Thank you.
This content has been marked as final.
Show 0 replies