Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What are the different dml commands in sql?

1090


Explain the difference in execution of triggers and stored procedures?

969


What are the three forms of normalization?

996


Define commit, rollback and savepoint?

979


Can we enter data in a table in design view?

913


What is the difference between python and sql?

940


Which is faster truncate or drop?

983


How to assign sql query results to pl sql variables?

995


What is clause in sql?

1056


Explain commit, rollback and savepoint.

933


what is the difference between truncate and delete statement? : Transact sql

1017


Does group by remove duplicates?

982


What are the advantages of sql?

1008


Differentiate between syntax and runtime errors.

1119


How to return an array from java to pl/sql?

1063