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?
- 6 Answers
- 9619 Views
- I also Faced
- E-Mail Answers
Answer Posted / xyz
aLTER TABLE emp ADD CONSTRAINT C3 CHECK (EMPNO < 300)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is sql basics?
What are properties of the transaction?
How insert into statements in sql?
Is trigger a stored procedure?
What is a parameter query?
What is the difference between explicit and implicit cursors in oracle?
Inline the values in PL/SQL, what does it mean.?
What is index example?
Why is sharding used?
How do I pipe the output of one isql to another?
What is sql engine in oracle?
How to avoid duplicate records in a query?
how are mysql timestamps seen to a user? : Sql dba
Is sql sequential or random?
What does <> sql mean?
