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
- 9609 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 equi join in sql?
what is foreign key? : Sql dba
How to fetch alternate records from a table?
What is the difference between nvl function, ifnull function, and isnull function?
How to write html code in pl sql?
What is mutating sql table?
What is a .db file?
Write a query to find the names of users that begin with "um" in sql?
What is the difference between in and between in sql?
Can I create table without primary key?
what is difference between delete and truncate commands? : Sql dba
What is difference between inner join and self join?
What is clause?
What are the triggers associated with image items?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
