|
|
|
How do I set the value of a Composite Foreign Key ? [message #2112 is a reply to message #2094] |
Fri, 21 June 2002 02:15 |
Mark Grimshaw
Messages: 73 Registered: June 2002
|
Member |
|
|
Hello,
I have a table which has a foreign key defined as follows
CREATE TABLE TEST
( ...
TEST_ID VARCHAR2(4),
OTHER_TABLE, CONSTRAINT
FOREIGN_KEY fkey FOREIGN KEY(TEST_ID,OTHER_TABLE.ID)
REFERENCES OTHER_TABLE(TEST_ID,OTHER_TABLE.ID)
)/
The question is how do I set the OTHER_TABLE composite foreign key when using the SQL Loader tool or is this
field updated automatically by Oracle ?
TYIA
|
|
|