Answer / rajeev

The CHECK constraint is used to limit the value range that
can be placed in a column.

If you define a CHECK constraint on a single column it
allows only certain values for this column.

If you define a CHECK constraint on a table it can limit the
values in certain columns based on values in other columns
in the row.

Answer / arihant

example of check constraint

CREATE TABLE Customer_Details(
Cust_ID Number(5) CONSTRAINT Nnull1 NOT NULL
CONSTRAINT Ccheck1 CHECK( Cust_ID BETWEEN 101 AND 105),
Cust_Last_Name VarChar2(20) CONSTRAINT Nnull2 NOT NULL,
Cust_Mid_Name VarChar2(4),
Cust_First_Name VarChar2(20),
Account_No Number(5) CONSTRAINT Pkey1 PRIMARY KEY,
Account_Type VarChar2(10) CONSTRAINT Nnull3 NOT NULL,
Bank_Branch VarChar2(25) CONSTRAINT Nnull4 NOT NULL,
Cust_Email VarChar2(30)
);

Answer / shaik

Check Constraint defines a condition that each row must satisfy.

create table emp(empid number,ename varchar2(15),salary
number,deptid number constraint emp_salary_min
CHECK(sALARY>1000));

How Switch (select or use) to a database.

0 Answers  

---

Can we store images in mysql database?

0 Answers  

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

0 Answers  

---

How do I download a mysql community server?

0 Answers  

---

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

1 Answers   TCS,

---

What does mysql_fetch_assoc do?

0 Answers  

---

What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  

---

What is a blob datatype?

0 Answers  

---

Explain MySQL architecture?

1 Answers  

---

what is the default port for mysql server? : Mysql dba

0 Answers  

---

How to return query output in html format?

0 Answers  

---

What is mysql_connect?

0 Answers  

---