Hi how Can I Add A Foreign key that references a table that
has composit primary key ?
example i had costumer table that has C_Id and SSN Both as
PK and another table has C_Id that must refernece C_Id in
Customers i done the usual way and got oracle error message
about uniqeness any ideas plz
- 2 Answers
- 3529 Views
- I also Faced
- E-Mail Answers
Answer Posted / mrs.priya
try to separate the composite key using str function when
referencing in another function to get only C_ID
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Is a rollback possible to any savepoint?
What is redo log?
What is bind variable in oracle 11g?
How to find out what oracle odbc drivers are installed?
How to download oracle database 10g xe?
What is blob data type in oracle?
What is a database table in oracle?
How to get a create statement for an existing table?
Can a formula column referred to columns in higher group ?
What to do if the startbd.bat failed to start the xe instance?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to test null values?
Explain the dml?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
