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
- 10354 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
Does sql view stored data?
What is bulk compiling in pl/sql.?
What are the two characteristics of a primary key?
How do I add a primary key to a table?
How do you create a db file?
How to load data with sql*loader?
What are the types of operators available in sql?
How to rename a table?
What is union?
what is a record in a database ? : Sql dba
Does sql*plus have a pl/sql engine?
Which function is used to return remainder in a division operator in sql?
What is crud diagram?
Define a temp table?
what is the use of double ampersand (&&) in sql queries?
