You're welcome.

>
>it works fine !
>
>Thank
>
>bernhart
>
>>If 'iagendadateid' is always sequential you can change where clause
>>

>>*WHERE apd.iagendadateid < vp_id ) pd ;
>>
>>WHERE apd.iagendadateid = vp_id-1 ) pd ;
>>

>>Otherwise
>>

>>UPDATE AgendaPhar  ;
>>			SET nstkjour = NVL( pd.nStkjourCor , 0 ) +1 ;
>>	FROM AgendaPhar;
>>	LEFT JOIN(;
>>			SELECT apd.nstkjour AS nStkjourCor , apd.itraiterId ;
>>					FROM  AgendaPhar apd ;
>>			WHERE apd.iagendadateid < vp_id ;
>>				AND NOT EXISTS ( SELECT * FROM  AgendaPhar ;
>>								WHERE itraiterId = apd.itraiterId ;
>>									AND iagendadateid < vp_id ;
>>									AND iagendadateid > apd.iagendadateid)) pd ;
>>		ON AgendaPhar.itraiterId = pd.itraiterId ;
>>	WHERE AgendaPhar.iagendadateid = vp_id
>>

>>