Logical Delete

[Xeneize]

Create a view on the table and define Instead of trigger

for example...

base table - tab
view - vw

create or replace trigger v1
INSTEAD of delete on vw
begin
  update tab
  set deleted = 'Y'
  where ....;
end;

and run delete command on the view

Thankz, that works perfect.