Is there any way you can write your own where statment in table operator property.
i.e. in my INSERT/UPDATE instead of specifying column directly , I want column to be in where clause like
nvl(field_name,'x')
i.e. My query look like
select x,y,z from tab1 where
x = vx and
y = yx
and nvl(z,'x') = nvl(yz,'x')
i.e. in my INSERT/UPDATE instead of specifying column directly , I want column to be in where clause like
nvl(field_name,'x')
i.e. My query look like
select x,y,z from tab1 where
x = vx and
y = yx
and nvl(z,'x') = nvl(yz,'x')