>>
>>>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.
When you feel 100% (I wish you do get 100% well, regardless of my question) and if you have a moment, could you, please, educate me on what is "factory sequence object"? Even if only in a few words. TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham