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
- 11393 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
When are we going to use truncate and delete?
What is the main reason behind using an index?
Can you join a table to itself?
Is primary key clustered index?
How do you update a table in sql?
What is sql and also describe types of sql statements?
what are the performance and scalability characteristics of mysql? : Sql dba
Does oracle use sql?
Why sql query is slow?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
what is the use of friend function? : Sql dba
Explain the purpose of %type and %rowtype data types with the example?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is the difference between an inner join and an outer join?
Is sql developer case sensitive?
