Skip to main content

Using an Oracle sequence while inserting data

You can genarate automatically primary key values while inserting data, using the sequence defined in Oracle.

In Talend Studio, the sequence is used in the Additional columns table, in the Advanced settings tab of the tOracleOutput component. Additional Columns are designed to handle DB columns which need DB SQL instructions.

The following example illustrates how to use an Oracle sequence while inserting data.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!