Suppose I have two tables 2 columns each.The 2nd column of the 1st is referencing 1st column of nd and 2nd column of 2nd table is referencing 1st column of the 1st table.How to insert data into these 2 tables?
2006-12-06 21:06:04 · 8 answers · asked by Partha G 1 in Computers & Internet ➔ Programming & Design
U have to specify any of the four columns as NULL, and start storing from their...
Oracle DB doen't support this type of cyclic references...
2006-12-06 21:12:05 · answer #1 · answered by Vaibhav 4 · 0⤊ 0⤋
1. First insert a value 2nd column of the 1st table.
2. Insert the data in the 2nd table with the value in the 1st column which are contained in the 2nd column of the 1st Table.
3. Update the 1st column of the 1st Table with the value which are contained in the 2nd column of the 1st Table
2006-12-06 22:55:42 · answer #2 · answered by Prabhat 1 · 0⤊ 0⤋
When you work on a database, you have to understand that you got to keep your design simple and manageable. If you challenge a system, then you got to invent one on your own. No one will buy this kind of confusing relatioships and you will be considered as a bad DBA.
Business objectives are more important than displaying your complicated tricks. If you really try to design a database cluster for supply chain management, then you will realise what a challenge is?.
2006-12-07 03:42:06 · answer #3 · answered by liketoaskq 5 · 0⤊ 0⤋
1. Confidentiality, privacy and security issues. 2. Data quality is not par with RDBMS 3. Data integrity is not par with RDBMS 4. Enterprise vulnerability may be higher. 5. Few Graphical or Statistical Capabilities 6. Propriety formats may limit archival quality of data 7. Require expertise and resources to administer 8. Cost of Data Conversion
2016-05-23 03:07:53 · answer #4 · answered by Anonymous · 0⤊ 0⤋
First, Create the Table.
Itz not at all possible to create the tables like that.
Itz like, Chicken First or Egg First Question...
2006-12-06 21:52:12 · answer #5 · answered by Ravi Nanjunda Rao 3 · 0⤊ 0⤋
first of all this is not "a nice DBMS Question", its kind of the "stupid kind of designing database question" one. but for your satisfaction:
if the tables are empty:
first delete the foreign key one of the table, drop the table that referenced by the key, insert the data to the existing one, then recreate the one that you drop, recreate the foreign key rule to that table.
if it doesn't empty:
dump your one of table data to a text or any format you like, delete the foreign key rule to that table, drop it, insert data to the existing one, recreate the dropped table, import the dumped data, recreate the foreign key rule.
THERE! you happy?
2006-12-06 21:26:44 · answer #6 · answered by Bistok D L 2 · 1⤊ 0⤋
Disable the constraints and Insert it. Are you trying to attend your first interview? Because my freind use ask such nasty questions before getting his first job. Best of luck
2006-12-07 12:14:39 · answer #7 · answered by raju 5 · 0⤊ 0⤋
HI
first up all i cant understand ur question pls clear
2006-12-06 21:42:13 · answer #8 · answered by Anonymous · 0⤊ 0⤋