D2K - How will u find the duplicate record in the detail block when we leave the text box

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 25 of 71

How will u find the duplicate record in the detail block when we leave the text box

Total Answers and Comments: 3

Last Update: October 03, 2006 Asked by: nitin kumat

Sponsored Links

Best Rated Answer

—

Submitted by: Rama Krishna,Yerra

We have to write the following Query in the "KEY-NEXT-ITEM' of the TEXT Item

select empno,rowid into :EMPNO,:ROWID from EMP e where rowid<(Select min(rowid) from emp where rowid<e.rowid)

Thanks&Regds

Ramki,TCS,Dp,HYd

Above answer was rated as good by the following members:
bc_sumanamara

August 02, 2006 12:25:10

Rama Krishna,Yerra

RE: How will u find the duplicate record in the detail...

We have to write the following Query in the KEY-NEXT-ITEM' of the TEXT Item

select empno rowid into :EMPNO :ROWID from EMP e where rowid<(Select min(rowid) from emp where rowid<e.rowid)

Thanks&Regds

Ramki TCS Dp HYd

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 03, 2006 03:09:27

adarsh_sp

Member Since: October 2006 Contribution: 13

RE: How will u find the duplicate record in the detail...

In the key next item trigger write the plsql code

select enum rowid into :ENUM :ROWID from EMPLOYEE where rowid<(Select min(rowid) from employee where rowid<e.rowid).

Is this answer useful? Yes | No

October 03, 2006 03:11:38

adarsh_sp

Member Since: October 2006 Contribution: 13

RE: How will u find the duplicate record in the detail...

In the KEY-NEXT-ITEM trigger write the plsql code

select enum rowid into :ENUM :ROWID from EMPLOYEE e where rowid<(Select min(rowid) from employee where rowid<e.rowid).

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank