One Star

add column to an Oracle table

Hi,
is it possible to add a colum to an oracle table? I have an Oracle database.
which component to use?
thanks.
Mouna
4 REPLIES
Moderator

Re: add column to an Oracle table

Hi,
is it possible to add a colum to an oracle table? I have an Oracle database.
which component to use?

We don't have a special component to add a column to DB, however, I think you can use tOracleRow and write a SQL to adjust the table structures.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: add column to an Oracle table

Yes, we should be able to add a column to a table using tOracleRow component. You can add your Alter statement in this component. Remember this component requires a mandatory input so add any input component like tRowGenerator or tFixedFlowInput.
However, adding a new column is not advisable through Talend. Can you please help us understand as to why you want to add a column to table using Talend?
One Star

Re: add column to an Oracle table

Hi,
thanks you for answering! I tried yesterday the tOracleRow, it didn't work but I think I wrote the query not correctly. I tried a second time few minutes ago and it worked. Thank you xdshi and vikram!!
vikram: i have a sequence of operations to do, and i try to exploit Talend for all the operations.
Mouna.

Re: add column to an Oracle table

Your welcome, Mouna.