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
- 9611 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
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
List the different type of joins?
How many types of sql are there?
What are pl sql data types?
how to get a list of indexes of an existing table? : Sql dba
How do I run sql profiler?
Can we join same table in sql?
How can we solve sql error: ora-00904: invalid identifier?
which operator is used in query for pattern matching? : Sql dba
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How do you delete duplicates in sql query using rowid?
Do we need commit after truncate?
What is trigger in pl sql?
what is union? : Sql dba
Why primary key is required?
