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?
Answer Posted / guest
hint:using row level and statement level trigger
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
When is the explicit cursor used ?
What is the purpose of the primary key?
What is procedure explain with example?
How to convert comma separated string to array in pl/sql?
What is mutating error?
Is primary key a clustered index?
What is on delete restrict?
How to create a menu in sqlplus or pl/sql?
what is the difference between truncate and delete statement? : Transact sql
What is %type in sql?
what is the difference between truncate and drop statements? : Sql dba
What is sql performance tuning?
explain the delete statements in sql
Does sqlite need a server?
What is sql*loader?