>
>>Why putting both the UPDATE and SET in the same expression is not a good suggestion?
>
>Because this is not documented as far as I know and you don't want to use undocumented features.
Naomi, this approach is documented and has been used by DBAs for years (among other reasons) as a way to simulate a factory sequence object.