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));

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers  

---

Is mysql easy to learn?

0 Answers  

---

What is ddl, dml, and dcl?

0 Answers  

---

Is mysql a backend?

0 Answers  

---

Is mysql server free?

0 Answers  

---

What is DDL in MySQL?

1 Answers  

---

What are slow queries?

0 Answers  

---

What is mysql community edition?

0 Answers  

---

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

0 Answers  

---

how to find 2nd highest salary in random database salary of employer.....

4 Answers  

---

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers  

---

Is mysql a nosql database?

0 Answers  

---