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
What is the use of double ampersand (&&) in sql queries? Give an example
Is it possible to create startup or shutdown trigger for on-schema?
What is package in pl sql with an examples?
What is the primary key?
What is the difference between null value, zero, and blank space?
tell us something about heap tables. : Sql dba
what is a trigger in mysql? : Sql dba
What steps server process has to take to execute an update statement?
How do I add a primary key to a table?
What is a pragma statement?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Why does sql need a server?
What is mutating table error?
How do I count rows in sql query?
explain what is mysql? : Sql dba