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
- 11636 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 difference between sql and oracle?
How can triggers be used for the table auditing?
How does pl sql work?
What programs use sql?
Is it possible to pass parameters to triggers?
How do you update f as m and m as f from the below table testtable?
What is graph sql?
What are types of exception?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
differentiate between float and double. : Sql dba
what is the difference between sql and t-sql? : Transact sql
Can a composite key be null?
What are different methods to trace the pl/sql code?
What is sql resultset?
What is the difference between distinct and unique in sql?
