Tutorial#61 Check constraint in Oracle SQL Database| How to Add Check Constraints

How to use Check Constraint in Oracle or what is Constraints and Types of Constraints in an Oracle SQL Database | integrity Constraints in SQL. Check Constraint is nothing but it allows you to specify a condition on each row in the table
Explaining constraints and types of constraints in Oracle or Constraints in Oracle SQL database or Constraints is nothing but a set of rules which is applied to the columns of any table in the database
------------------------------------
Assignment link :
-----------------------------------

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

[hrushinathkale]

Very Nice Video, Thank you so much from my bottom of heart.

[huzafaarshad]

can you tell me how to apply check constraint on date ?

[amanahmed]

why you are writing CONSTRAINT ch_con

[akashpatel]

create table supplier(
supplier_id INT,
supplier_name varchar(20),
gender varchar(10)
);
ALTER TABLE supplier
add constraint check_gender
check(gender in('male', 'female'));

insert into supplier values(11, 'akash', 'xyz');

select * from supplier;

sir its not showing error why ?