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
Is mysql a server or database?
What is mysql url?
How we can see all indexes defined for a table in mysql?
What is the full meaning of mysql?
How do I uninstall mysql connector?
What is the use of count function in mysql?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
What is a result set object?
Does facebook still use mysql?
How do I get a list of table names in mysql?
How can you handle the –secure-file-priv in mysql?
How do you know if your mysql server is alive?
How can you plan the logshipping before processing?
How do I run mysql on a mac?
What are Heap tables?