On 04/10/2011 16:51, J.V. wrote:
> What is the absolute fastest way to populate a primary key / id column
> from a named db sequence (disabled constraints and want to renumber the
> primary key / id column from sequence.
>
> cannot use auto inc or serial column because need to use generic
> hibernate mapping files for multiple DB's in the end, but want a stored
> proc to simple reorder a primary key int column pulling from a named
> sequence, if there is a single command.
Something like this? -
update my_table set my_column = nextval('my_sequence');
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie