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 This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are date and time intervals?
How can we get total number of records by query in mysql?
How can we find out which auto increment was assigned on Last insert?
Is mysql and sql are same?
What is database migration in mysql?
What is mysql enterprise edition?
What is mysql routine?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What is a heap table?
What is mysql good for?
What is difference between microsoft sql and mysql?
how to take mysql database backup?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What is pdo mysql?
Write a query to fetch common records between two tables using mysql?