Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11130 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh babu
create check constraint is the best way to restrict the
limited number of entries,because the constraint won't take
a separate space,but Trigger required separate memory
space.perhaps the trigger got error,it would affect all
entries in table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between the implicit and explicit cursors?
How can I see all tables in sql?
How many functions are there in sql?
What is sql keyword?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is the advantage of index in sql?
How does rowid help in running a query faster?
What is difference between pls_integer and integer?
What is a constraint? Tell me about its various levels.
What is full join in sql?
Is sql pronounced sequel or sql?
Is stored procedure faster than query?
Which is faster subquery or join?
What is a sql schema used for?
What is dynamic query?
