Answer Posted / surya
It is used to avoid invalid and inconsistence data into the
data base table.
For example if you specify like this
sal int Check(sal>=1000)
and trying to insert value below 1000 in the sal
column,they won't accept you.That means it restrict the
data in the database table.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What do you mean by cdb and pdb in oracle 12c?
How to call a stored function in oracle?
How to export your own schema?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is a trace file and how is it created in oracle?
What is a nvl function? How can it be used?
Is insert autocommit in oracle?
What do you mean by group by clause?
What is the use of aggregate functions in oracle?
How to write a left outer join with the where clause in oracle?
how to clone 9i Database on to 10g Database.
What is a proxy object?
How to use regular expression in pattern match conditions in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.