Inserting sequence

[BB123]

When using the SQL window to insert data, if the field is a sequence is there any way to automatically have the next sequence number inserted (something similar to using sequence.nextval)? Thanks.

 

[Marco Kalter]

There is no functionality for this in the SQL Window. However, if you arrange this in a before insert row level trigger, then it will work in the SQL Window and in any other tool that inserts records in this table.