Rama Krishna,Yerra

• Aug 2nd, 2006

 

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

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

 

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).

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

 

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).