have been wondering for quite a while

From: William Dong <William_Dong_at_nylim.com>
Date: Mon, 02 Jul 2001 12:54:17 -0700
Message-ID: <F001.0033F618.20010702124641@fatcity.com>

DBAs:

On the user_constraints view, you can find the constraint_type has five distinct values:
C, O, P, R, U, and V.

C=check,
P=primary key,
R=foreign key,
U=unique key.

What about O and V?

If I assume O=optional(null/not null), I really can not guess V.

Anyone can help?, Thanks in advance.

William

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: William Dong
  INET: William_Dong_at_nylim.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 02 2001 - 14:54:17 CDT