Interested to Buy Any Domain ? << Click Here >> for more details...
What are various constraints used in SQL?
- 1 Answers
- 3745 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 ordinary table in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are the different types of failures that occur in Oracle database?
what diffrence between function and procedure?
How to get a list of all tables in the database?
Can I create users through internet explorer in oracle 10g?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
when do u go for hash partitioning?
How to create a table index in oracle?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
What is oracle and what are its different editions?
Oracle General 
