Re: Trivial question coming!

From: Joel Garry <joelga_at_rossinc.com>
Date: 1997/02/13
Message-ID: <1997Feb13.182708.6107@rossinc.com>#1/1

In article <32FB68AA.4E93_at_saxe.com> JP Soria <jpsoria_at_saxe.com> writes:
>Is it possible to INSERT INTO a table a blank row, where a Key is
>involved?

It depends on your definition of the key. If it is a primary key, then you can only have one if you haven't specifically prohibited it with other constraints. If you disable all integrity checking, you can have many. See the Data Integrity chapter in the System Concepts manual. It's not such a trivial question after all, eh?

>
>--
>JP Soria
>Oracle7 DBA/Software Tester
>Email: jpsoria_at_saxe.com
>"Failing to plan = planning to fail"

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O

Received on Thu Feb 13 1997 - 00:00:00 CST