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
- 11369 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 blind sql injection?
What is dml and ddl?
what are the types of join and explain each? : Sql dba
What is informix sql?
What is a design view?
what is the difference between $message and $$message? : Sql dba
what is column? : Sql dba
How to place comments in pl/sql?
How can you fetch common records from two tables?
What are the two types of exceptions in pl/sql?
What is the purpose of normalization?
Which are the different character-manipulation functions in sql?
What is substitution variable in pl sql?
How do you clear the screen in sql?
What are different methods to trace the pl/sql code?
