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
- 10348 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
Explain cursor types?
what are the advantages and disadvantages of views in a database? : Sql dba
What is the current version of postgresql?
What are the main features of cursor?
What is compilation error in pl sql?
what are the nonstandard string types? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
How to fetch alternate records from a table?
What is crud stand for?
What are literals in sql server?
How many sql databases can you have on one server?
What is view explain with example?
List the different type of joins?
What do we need to check in database testing?
what are all types of user defined functions? : Sql dba
