I'm not sure how your question relates to Visio, unless you are using the
database modeling solution and reverse engineering from the Oracle server.
If you are looking for guidance on the SQL language or database creationg
steps, you will want to ask in an SQL forum or Oracle newsgroup, rather
than here.
FYI - the Visio database modeling solution does not deal with data, only
with the Schema (structure) of the database entities.
Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: "nLinked" <
[email protected]>
Subject: In SQL database, do I need to fill in rows under a foreign key
attribute?
Date: Tue, 25 Dec 2007 11:39:54 -0000
Lines: 1
Message-ID: <
[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
X-MS-CommunityGroup-MessageCategory: {E4FCE0A9-75B4-4168-BFF9-16C22D8747EC}
X-MS-CommunityGroup-PostID: {38E75A23-F1B3-4CFF-9258-8259A07832D3}
Newsgroups: microsoft.public.visio
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.visio:1385
NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
X-Tomcat-NG: microsoft.public.visio
Say I've made a table in an Oracle SQL database with a primary key column,
some attribute columns, and a foreign key column. I have to populate the
table with data. For the foreign key column, do I have to populate that as
well (using INSERT INTO VALUES, or INSERT INTO - SELECT - FROM), or do I
not
fill in anything for the foreign key column because it will take data
automatically from the other table's primary key?
