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.
From the manual:
CONSTRAINT_TYPE
Type of constraint definition:
C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option, on a view)
O (with read only, on a view)
-Original Message-
Sent: Monday, July 02, 2001 1:47 PM
To: Multiple
William Dong wrote:
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.
null is a check constraint
v is (I believe) a view constraint
From: William Dong [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: have been wondering for quite a while
Date: Mon, 02 Jul 2001 12:46:41 -0800
DBAs
Hi,
CONSTRAINT_TYPE
VARCHAR2(1)
Type of constraint definition:
C (check constraint on a table)
P