From William_Dong@nylim.com Mon, 02 Jul 2001 12:54:17 -0700 From: "William Dong" Date: Mon, 02 Jul 2001 12:54:17 -0700 Subject: have been wondering for quite a while Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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).