Hi everyone,
I have a challenge case as: I have a select list page item and one IG report. I want to when I choose a page item valued by 'W', it allows IG report only one row. While I choose another value, it still allows many rows for IG report.

I try after submit with code :

Declare 
v_count number;
Begin

select count(*)
into v_count
from E_EDUFIT_MARKS_DETAIL md, e_edufit_marks m
where md.marks_id = m.marks_id
and m.type_marks = 'W'
AND md.marks_id = :P2645_MARKS_ID;

if v_count > 1  then return 'FALSE';
end if;
end;

I think it may be successfully when one row is created before. I wonder that when create new records, user click add row (over 2 rows) it wil be not run. I have not found a way to solve that problem. I hope you help me have a good idea. Thank in advance.

create unique index IX on EMP  ( case when type = 'W' then empno end );