|
-
 Originally Posted by yxez
How do i pick up the EMP.emp_id and populate it to
EMP_LOANS.emp_id?
That depends on your app. But you cannot expect Oracle to track that value. Assuming that the pkey of the parent table is set using a trigger then use the returning clause on the insert into EMP table in order to use it for the insert into the EMP_LOANS table.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote