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 are the different dml commands in sql?
Explain the difference in execution of triggers and stored procedures?
What are the three forms of normalization?
Define commit, rollback and savepoint?
Can we enter data in a table in design view?
What is the difference between python and sql?
Which is faster truncate or drop?
How to assign sql query results to pl sql variables?
What is clause in sql?
Explain commit, rollback and savepoint.
what is the difference between truncate and delete statement? : Transact sql
Does group by remove duplicates?
What are the advantages of sql?
Differentiate between syntax and runtime errors.
How to return an array from java to pl/sql?