"MERGE INTO MERCURY_VRM_CACHE cache
USING (
? SELECT :1 reg, :2 colour, :3 fuel, :4 transmission, :5 regDate, :6 doors, :7 capId, :8 capCode, :9 bodyType, :10 previous
? FROM DUAL) incoming
ON (cache.registration = incoming.reg)
WHEN MATCHED THEN
? UPDATE SET cache.colour = incoming.colour, cache.fuel = incoming.fuel, cache.transmission = incoming.transmission,
???????????? cache.date_of_registration = incoming.regDate, cache.doors = incoming.doors, cache.cap_id = incoming.capId, cache.cap_code = incoming.capCode,
??? ??? ??? ?cache.body_type = incoming.bodyType, cache.previous_owners = incoming.previous
WHEN NOT MATCHED THEN
? INSERT (cache.REGISTRATION, cache.COLOUR, cache.FUEL, cache.TRANSMISSION, cache.DATE_OF_REGISTRATION, cache.DOORS, cache.CAP_ID, cache.CAP_CODE, cache.BODY_TYPE, cache.PREVIOUS_OWNERS)
? VALUES (incoming.reg, incoming.colour, incoming.fuel, incoming.transmission, incoming.regDate, incoming.doors, incoming.capId, incoming.capCode, incoming.bodyType, incoming.previous)"

?

select *? from stockinf where stockcode = :1