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
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?
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.
