We can use Check constraint to restict the values of any column.

how do you restrict number of rows for a particular value
in a column.For example:there is a table called
fruits,having apples,bananas ,papayas.I dont want to have
more than 100 apples in that table ,so how can u restrict
number of rows for apple to hundred?

Question Posted / gk

6 Answers
11182 Views
I also Faced
E-Mail Answers

Answer Posted / gk

We can use Check constraint to restict the values of any
column.

Is This Answer Correct ?

12 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is interval partition?

1001

Does execute immediate commit?

1160

What are the 3 modes of parameter?

1109

How to select unique records from a table?

1009

Is sql free?

895

what are the disadvantages of mysql? : Sql dba

1085

What is record type in pl sql?

948

What is crud stand for?

944

Where is pl sql used?

914

List different type of expressions with the example.

900

How do you identify a primary key?

1018

Explain the difference between rename and alias?

975

what is an index? : Sql dba

943

what is a composite key ? : Sql dba

1000

What is number function in sql?

921