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

[android1686764069]

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]

Hi @android devops​ 

SEQ_ID_EXPDT is the name of sequence defined on your database.

[android1686764069]

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]

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