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 / gk
We can use Check constraint to restict the values of any
column.
Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Where is pl sql used?
Where is sql database stored?
How to display Row Number with Records in Oracle SQL Plus?
How can you know that statistics should be updated?
What is a system versioned table?
What does partition by mean in sql?
State few characteristics of pl/sql?
How many columns should be in an index?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What's the procedure?
define sql delete statement ? : Sql dba
How to use boolean type in select statement?
how to include numeric values in sql statements? : Sql dba
Why do we need unique key in a table?
How delete all records from table in sql?