Answer Posted / 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)
);

Is mysql a server or database?

872

---

What is mysql url?

851

---

How we can see all indexes defined for a table in mysql?

906

---

What is the full meaning of mysql?

952

---

How do I uninstall mysql connector?

926

---

What is the use of count function in mysql?

1012

---

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1108

---

What is a result set object?

931

---

Does facebook still use mysql?

916

---

How do I get a list of table names in mysql?

911

---

How can you handle the –secure-file-priv in mysql?

923

---

How do you know if your mysql server is alive?

1052

---

How can you plan the logshipping before processing?

2310

---

How do I run mysql on a mac?

943

---

What are Heap tables?

1537

---