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
- 11611 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
What is the difference between null value, zero, and blank space?
How do I run sql?
What do you know by pl/sql cursors?
How do you copy a table in sql?
How do I partition a table in sql?
What is 19 null in sql?
What is auto increment feature in sql?
What is pl sql block structure?
How many disk partitions should I have?
What is the use of prepared statement?
What is composite data type in pl sql?
What is the syntax and use of the coalesce function?
Explain the difference between rename and alias?
Does truncate table reset auto increment?
Is subquery faster than join?
