Populating Display Item Value On Query In Oracle Forms
Select Ename into :datablock.dspname
where ecode = :datablock.ecode;
— Field dspname in datablock will be populated with the value
when others then
— you can ignore error
You can write multiple plsql blocks in post-query trigger for different tables.