Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Creating an view that updates related tables
Hello,
Can someone tell me how to create a view of two related tables so I can Insert data into these tables at once. I have tried to make a view that joins two related tables but since I am Insetring into this view, I would assume that I have to have the Primary key from the parent table and the forigen key from the child table so I can insert data into each field. Oracle is telling me I have dupliacte coumns even though I am defining them as table1.field and table2.field. Can anyone help? Received on Thu Jan 25 2001 - 12:51:40 CST