topic Re: add column to an Oracle table in Talend Studio

add column to an Oracle table

Anonymous — Sat, 16 Nov 2024 12:02:48 GMT

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

Re: add column to an Oracle table

Anonymous — Thu, 25 Apr 2013 03:14:55 GMT

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

Re: add column to an Oracle table

Anonymous — Thu, 25 Apr 2013 03:18:04 GMT

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?

Re: add column to an Oracle table

Anonymous — Thu, 25 Apr 2013 08:46:12 GMT

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

Anonymous — Thu, 25 Apr 2013 09:31:34 GMT

Your welcome, Mouna.