Interested to Buy Any Domain ? << Click Here >> for more details...
What are various constraints used in SQL?
- 1 Answers
- 3766 Views
- Polaris, I also Faced
- E-Mail Answers
SQL constraints are used to specify rules for the data in a table.
NOT NULL - Indicates that a column cannot store NULL value
UNIQUE - Ensures that each row for a column must have a unique value
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Ensures that a column (or combination of two or more columns) have an unique identity which helps to find a particular record in a table more easily and quickly
FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table
CHECK - Ensures that the value in a column meets a specific condition
DEFAULT - Specifies a default value when specified none for this column
| Is This Answer Correct ? | 2 Yes | 0 No |
how many columns can a plsql table have
What is the difference between a primary key & a unique key?
What is the use of file param in imp command?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to get execution statistics reports on query statements?
What is oracle server autotrace in oracle?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
How to open and close an explicit cursor in oracle?
How to create a table in a specific tablespace?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What are the different types of synonyms?
What is tns name?
Oracle General 
