Answer / gk

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

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.

Answer / guest

hint:using row level and statement level trigger

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;

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.

Answer / xyz

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

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

What are the properties of a transaction?

0 Answers  

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

What is sharding in sql?

0 Answers  

select 10 from dual; y its showing all the rows with 10?

1 Answers  

What are conditional predicates?

0 Answers  

How can you fetch first 5 characters of the string?

0 Answers  

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

What is a schema? How is it useful in sql servers?

0 Answers  

What are sql queries used for?

0 Answers  

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

What are sql functions? Describe in brief different types of sql functions?

0 Answers