oracle update only first occurrence

I have table with two columns

rule_id , passenger_type 

with

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