What are various constraints used in SQL?
- 1 Answers
- 2964 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 ? | 1 Yes | 0 No |
What is forall Statement ?
how the indexes are stored in the Oracle Database?
WHAT IS ecc 6.0
How to create a new user account in oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
what is query and types of query
Explain the use of full option in exp command.
How to open and close an explicit cursor in oracle?
How to assign data of the deleted row to variables?
Oracle General 
