thank you very much :-)
On Sunday, 18 December 2022 at 19:47:59 UTC+8 Evgenij Ryazanov wrote:
> Hi!
>
> If you don't care about exact ordering, the fastest way is
> UPDATE tableName SET columnName = ROWNUM();
>
> If you want to preserve it, a slower command is needed:
> MERGE INTO tableName USING
Hi!
If you don't care about exact ordering, the fastest way is
UPDATE tableName SET columnName = ROWNUM();
If you want to preserve it, a slower command is needed:
MERGE INTO tableName USING
(SELECT columnName, ROW_NUMBER() OVER(ORDER BY columnName) FROM tableName)
T(columnName, R)
ON tableName.c
