Answer Posted / rajshri.20
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 |
Post New Answer View All Answers
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Explain the difference between sql and oracle?
Does oracle partitioning improve performance?
How to synchronize 2 schema's objects?
How to use "if" statements on multiple conditions?
What are the differences between number and binary_float in oracle?
What do you understand by a database object?
what is port in oracle? how is it related to database application.
what's query optimization and without use of IN AND Exist can we get another way data from query
How to create a stored program unit?
What is a system tablespace?
Explain the difference between a procedure and a function?
What is a parameter file in oracle?
What is the use of oracle?
How to create a testing table in oracle?