Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / guest

Answers were Sorted based on User's Feedback



how do you restrict number of rows for a particular value in a column.For example:there is a table..

Answer / gk

We can use Check constraint to restict the values of any
column.

Is This Answer Correct ?    12 Yes 3 No

how do you restrict number of rows for a particular value in a column.For example:there is a table..

Answer / suresh babu

create check constraint is the best way to restrict the
limited number of entries,because the constraint won't take
a separate space,but Trigger required separate memory
space.perhaps the trigger got error,it would affect all
entries in table.

Is This Answer Correct ?    2 Yes 1 No

how do you restrict number of rows for a particular value in a column.For example:there is a table..

Answer / guest

hint:using row level and statement level trigger

Is This Answer Correct ?    1 Yes 1 No

how do you restrict number of rows for a particular value in a column.For example:there is a table..

Answer / bikash khuntia

We have to create a trigger for that which is one of the
way for the solutuion as below:-

create or replace trigger trigger_name
before insert on table_name
for each row
DECLARE
v_count number;
begin
select count(apple) into v_count from table_name;
if v_count=100 then
raise_application_error('-20011','u cant insert more than
100 apples in the table');
end if;
end;

Is This Answer Correct ?    1 Yes 1 No

how do you restrict number of rows for a particular value in a column.For example:there is a table..

Answer / 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

how do you restrict number of rows for a particular value in a column.For example:there is a table..

Answer / xyz

aLTER TABLE emp ADD CONSTRAINT C3 CHECK (EMPNO < 300)

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

What is difference between sql and oracle?

0 Answers  

How do I audit the sql sent to the server?

0 Answers  

How to place comments in pl/sql?

0 Answers  

What are indexes, and what are the different types?

3 Answers  

what is “go” in t-sql? : Transact sql

0 Answers  

What is the use of sqldataadapter?

0 Answers  

how to findout the 100th maximum salary

28 Answers   Amdocs,

What is correlated sub-query?

7 Answers   Oracle,

What are local and global Indexes and where they are useful.

0 Answers  

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

When should I use nosql database?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories