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
- 11397 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 a table in a database?
Is it possible to update views?
How does one load ebcdic data? : aql loader
How much does a sql dba make? : SQL DBA
How can a pl sql block be executed?
what are set operators in sql? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what is datawarehouse? : Sql dba
What is Difference Between Unique and Primary Key Constraints?
Is sqlite thread safe?
Name the operator which is used in the query for pattern matching?
Why are sql stored procedures used?
What is materialized view. What are different methods of refresh?
Why we use triggers in mysql?
Which are the different types of indexes in sql?
