Insert sequence id number

[kizziebutler]

Hello,

I am trying to insert sequence_id when a new record is created, but not sure the best way to tackle this.

i.e., create squence seq_passenger_id
increment by 1
start with 1
order;

I have try to create ON BUTTON PRESS "WHEN CREATE RECORD"
select seq_passenger_id.nextval
into assenger.pid
from dual;

but it complains that dual needs to be declared, any help please.

 

[lewisp]

The best way is thorugh a PRE-INSERT trigger.

Why is dual not declared? Either you are not logged on when you compile the PL/SQL or something is fundamentally wrong with your database. Seek the assistance of your DBA.