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

### In this section

* [Create the Oracle table and sequence](https://help.qlik.com/talend/en-US/components/8.0/oracle/create-oracle-table-and-sequence)
* [Read data from a text file and insert the data into Oracle's PERSON table](https://help.qlik.com/talend/en-US/components/8.0/oracle/read-data-from-text-file-and-insert-data-into-oracle-s-person-table)