In the tabular form how to check the duplicate entry at the time of data feeding.

Interview Candidate
Dec 10th, 2006
2
3692

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

Anil Kumar

Dec 12th, 2006

declare
a number;
begin
first_record;
a:=system.current_record;
for i in a..system.current_record-1 loop
checking code
end loop;

Abbireddy Anil Kumar

Dec 15th, 2006

declare
serch_item number;
a number;
b number;
begin
serch_item:=:emp.empno;
b:=:system.cursor_record;
first_record;
a:=:system.cursor_record;
for i in a..b-1 loop
if srich_item=:emp.empno then
message('Employee No Already Exists')
raise form_trigger_failre;
else
next_record;
end if;
end loop;
end;