Home » SQL & PL/SQL » SQL & PL/SQL » table creation
table creation [message #23704] Sun, 29 December 2002 20:39 Go to next message
Palaniappan
Messages: 4
Registered: December 2002
Junior Member
How to create master details tables

Report message to a moderator

Re: table creation [message #23707 is a reply to message #23704] Mon, 30 December 2002 03:28 Go to previous message
Remi Visser
Messages: 44
Registered: December 2002
Member
You do that by defining a primary key inyour master table and defining a foreign key in you detail (child) table referring the primary key in the master table.

Example:

[[REMIVISSER@ORA-0000.COM]] create table master (k number primary key);

Table created.

[[REMIVISSER@ORA-0000.COM]] create table detail(l number constraint fk_detail references master(k));

Table created.

[[REMIVISSER@ORA-0000.COM]] insert into master values(1);

1 row created.

[[REMIVISSER@ORA-0000.COM]] insert into detail values(1);

1 row created.

[[REMIVISSER@ORA-0000.COM]] insert into detail values(2);
insert into detail values(2)
*
ERROR at line 1:
ORA-02291: integrity constraint (REMIVISSER.FK_DETAIL) violated - parent key not found

Good luck!

Report message to a moderator

Previous Topic: Exiting a sqlplus batch session
Next Topic: got an error while sending mail from Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 01:28:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.