Hi all,

I am not sure where to post this. Please could you check the below case and advise what would be the best way to proceed.

I have a table with more than 10K records in it. I want to restrict any data insert into the table if the value of column 1 is 'xyz'. The table currently has multiple rows with column 1 as 'xyz' and these rows should remain in the table.

May be this can be achieved by triggers, but I am not sure if it would work as there are already rows with column 1 as 'xyz'.

Thank you for your time.