oracle update only first occurrence

I have table with two columns

rule_id , passenger_type 


PRIMARY KEY (rule_id , passenger_type)

I’m trying to update passenger_type=’CNN’ where
passenger_type in (‘C02′,’C03′,’C04’)

but only the first occurrence for each rule_id

I’m using oracle db

Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.