Interested to Buy Any Domain ? << Click Here >> for more details...
What are various constraints used in SQL?
- 1 Answers
- 3840 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 |
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How can I get column names from a table in oracle?
How to fetch the row which has the max value for a column?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
How to connect to a local oracle 10g xe server?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
what are actual and formal parameters?
What is the function of Redo Log ?
Which is better Oracle or MS SQL? Why?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
Oracle General 
