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
- 11410 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
Can we perform dml on view?
how to shut down the server with 'mysqladmin'? : Sql dba
How do I create a sql script?
When is a declare statement required?
write an sql query to find names of employee start with 'a'? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How to create your own reports in sql developer?
How do sql databases work?
Are views faster than queries?
What is trigger in pl sql with examples?
What is sp_helptext?
How does sql developer connect to oracle database?
What is the difference between join and natural join?
what is a record in a database ? : Sql dba
What is the maximum number of columns in sql table?
