Not done for my question
A reader, October 14, 2020 - 7:59 am UTC
Thank for your code. I try it which follows your sample, I run it on DB:
create unique index IX on e_edufit_marks m ( case when m.type_marks = 'W' then m.marks_id end );
where marks_id is a primary key
But when I test on oracle apex with page_item selected 'W', it still allow add over 1 row. Can you make more clear for me?
October 15, 2020 - 4:32 am UTC
What happens when you press Save in the IG ?
Follow
A reader, October 16, 2020 - 6:18 am UTC
When I press Save on IG button, it will allow one row for any value of page_item. And when editing the old record, Save button process nothing.
But I do not use Save button to create a new record.