Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Parent Child Table Relationship
This is a discussion on Parent Child Table Relationship within the Oracle forums, part of the Databases category; Do you think – that is possible to have a foreign key enable on a child table with the data which is not available in parent table....
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
01-17-2008
|
|||
|
|||
|
Parent Child Table Relationship
Do you think – that is possible to have a foreign key enable on a child table with the data which is not available in parent table.
|
| Sponsored Links |
|
01-17-2008
|
|||
|
|||
|
Re: Parent Child Table Relationship
its not possible to enter data in child table which is not available in parent table.
it will gives an error like integrity constraint voilated.parent key not found,when ur trying to insert.
|
|
01-17-2008
|
|||
|
|||
|
Re: Parent Child Table Relationship
If you can do that ,then what is the use of foreign key then.
|
|
02-06-2008
|
|||
|
|||
|
Re: Parent Child Table Relationship
Quote:
|
|
04-03-2008
|
|||
|
|||
|
Re: Parent Child Table Relationship
Hi All,
One silly question from my side. Is it possible to have a parent child relationship with parent as a database block and child as non database block ? Both of them are having a cust_id column as a primary key. Thanks and Regards, Sandeep
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Method to excute child objects script | ypraveen_77 | QTP | 2 | 01-06-2008 02:54 AM |
| Child tables cat_id is not deleting | priyaranjan_BISWAL | MY SQL | 0 | 09-29-2007 03:47 AM |
| Selected project does not have any child BC | mail2diptesh | Seibel | 1 | 07-24-2007 03:12 AM |
| Populate parent child hierarchy using Informatica | Geek_Guest | Data Warehousing | 0 | 07-08-2007 08:19 AM |
| Child appear to be read-only until i do a manual refresh | Lokesh M | Seibel | 0 | 07-02-2007 12:04 PM |
All times are GMT -4. The time now is 08:33 PM.
