Series: Subject: Topic:
Question: 24 of 74
How will you avoid duplicate entries in the forms?
we can restrict duplicate entries in the form
cheak which coloum can be maintained uniqueness
for that coloumn item text
write a trigger when_key_navigate
declare
e_empno number(5);
cursor c is select * from emp;
begin
for i in e_emp loop
if e_empno= i.empno then
dbms_output.put_line("already exist");
end if;
end loop;
:empno=e_empno;
end;
cheak which coloum can be maintained uniqueness
for that coloumn item text
write a trigger when_key_navigate
declare
e_empno number(5);
cursor c is select * from emp;
begin
for i in e_emp loop
if e_empno= i.empno then
dbms_output.put_line("already exist");
end if;
end loop;
:empno=e_empno;
end;
Asked by:
Interview Candidate | Asked on: Jun 26th, 2007
Related Answered Questions
Related Open Questions
User Panel
Categories
Interview Coaching
Connect
Ads
Interview Question
Latest Questions
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
