Question

What are the various constraints used in Oracle?

Answer 1

Following are constraints used:

• NULL – It is to indicate that particular column can contain NULL values
• NOT NULL – It is to indicate that particular column cannot contain NULL values
• CHECK – Validate that values in the given column to meet the specific criteria
• DEFAULT – It is to indicate the value is assigned to default value

Answer 2

These are the following constraints used:

1. NULL: It is to indicate that a particular column can contain NULL values.
2. NOT NULL: It is to indicate that particular column cannot contain NULL values.
3. CHECK: Validate that values in the given column to meet the specific criteria.
4. DEFAULT: It is to indicate the value is assigned to a default value.