Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the Limitations of a CHECK Constraint ?

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


Please Help Members By Posting Answers For Below Questions

What do you mean by cdb and pdb in oracle 12c?

1059


How to call a stored function in oracle?

1018


How to export your own schema?

1007


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?

1989


what's query optimization and without use of IN AND Exist can we get another way data from query

2141


What is a trace file and how is it created in oracle?

1058


What is a nvl function? How can it be used?

1031


Is insert autocommit in oracle?

1068


What do you mean by group by clause?

1045


What is the use of aggregate functions in oracle?

1026


How to write a left outer join with the where clause in oracle?

1084


how to clone 9i Database on to 10g Database.

2339


What is a proxy object?

1061


How to use regular expression in pattern match conditions in oracle?

1041


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.

2123