c# - How to create sequence for foreign key in oracle? -
i have 1 table employees columns id number(2) primary key, name varchar2(20) not null, pid number(2) not null.
pid has foreign key id in same table.
i want create combo box contains values column name. also, when select value column name, after clicked on button, have create value pid in table employees.
i tried insert auto_increment sequence pid, wasn't work, because it's not primary key.
so, don't have idea how solve step. because it's complicated when have columns in 1 table.
is id value equal pid ?
if yes, guess have database design issue.
if not, can try use sequence of id column.
Comments
Post a Comment