topic Re: tDBoutput (Oracle) : confused with line insertion and additional columns in the advances settings in Talend Studio

tDBoutput (Oracle) : confused with line insertion and additional columns in the advances settings

android1686764069 — Fri, 15 Nov 2024 21:36:36 GMT

Hello

I have simple job to insert lines in a oracle database

My table is name EXP_DT and looks like this :

When I insert a new line, ID should automatically increase by 1.

my input file is like this:

in dboutput, in the settings, my schema is defined like my input file : I have 2 columns "name" and "entity"

In the advanced settings, i am confused. thias is what I was told tu put:

for NOM( ie NAME): i got it; i put the columms names
for position, i think i got it: it define whether my new colmun is before, after or replacing the reference column (Colonne the reference in my pic)
for SQL expression, I dont know where "SEQ_ID_EXPDT" comes from. Whats does it mean? I understand nextval is to increase the value by 1. But whats is SEQ_ID_EXPDT? EXPDT looks like my table name without the underscore "_". Was SEQ_ID_EXPDT defined somewhere I'm not aware of?

anselmopeixoto — Sun, 09 Jul 2023 21:12:16 GMT

Hi @android devops

SEQ_ID_EXPDT is the name of sequence defined on your database.

android1686764069 — Mon, 10 Jul 2023 08:29:45 GMT

ok thanks,

can someone tell me how I can I get the name of a sequence in a oracle database?

My colleague told me to use this sequence name but if he wasn't here, houw could I have access to this sequecne name

anselmopeixoto — Mon, 10 Jul 2023 21:09:23 GMT

I would use a tool like DBeaver to browse the database and identify the sequences available.

But you could use other methods like querying the database:

select sequence_owner, sequence_name from dba_sequences;

https://stackoverflow.com/questions/21738117/how-can-i-get-all-sequences-in-an-oracle-database