I've searching abou an OBE or another example to create and form with PK from database or the way is create only with sequence?
My tables are:
USER_ASSIGN (SECOND PK)
How i can assign the Key to the next ID_ROL (Detail) in run time?
Your question is about basic oracle sql/plsql knowladge. You have to read about it first then Apex development.
In oracle for populate ID you can use sequence (name_sequence.nextval).
insert into your_table (ID, COL1) values (name_sequence.nextval, 'your data');
I know pl/sql.
I was reviewing examples of PL / SQL and applied generally use keys with fields sequences and not from table base fields.
Not if it's something special in APEX or if it's okay to use as a base table field keys. Why try to make a simple example form master / detail this turned complicated. Especially when I have to assign the key to the field of the detail table (autogenerated). I don't know how do it.
thank you very much