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
- 11367 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashwin
You can create a sequence named seq_fruit as below .
create sequence seq_fruit
increment by 1
start with 1
maxvalue 100
minvalue 1
cycle
cache 10
if the current count ie currval of seq_fruit is 100 and
after this if u r inserting a new row in fruit table as
following
insert into fruit values(seq_fruit.nextval,30,40);
after the execution of this statement next value for apple
will be entered as 1 and not 101.
The cycle keyword will avoid the count of fruit column to go
beyond 100.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how can we destroy the cookie? : Sql dba
What is the use of <> sql?
Can unique keys be null?
what is commit? : Sql dba
What is triggering circuit?
In pl/sql, what is bulk binding, and when/how would it help performance?
What does partition by mean in sql?
How do I run a sql trace?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What are inbuilt functions in sql?
Why use truncate instead of delete?
Why trigger is used in sql?
What are the differences between in and exists clause?
What is a crud api?
Is sql procedural language?
