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
- 11348 Views
- I also Faced
- E-Mail Answers
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 a sql statement?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is rownum?
what are different types of keys in sql?
What is coalesce in sql?
what is the difference difference between procedure and packages
What is materialized view in sql?
How can triggers be used for the table auditing?
Is it possible to update views?
What is procedure in pl sql?
What are the various restrictions imposed on view in terms of dml?
Are there any features that are decommissioned in 11g that are not present in 11g?
What are all the common sql functions?
What is the difference between rename and alias?
How sql query is executed?
