How to update a column by repositioning the values in a random order

Okay, so this table will work as an example of what I am working with. This table consists of the name of someone and the order they are in compared to others:

NAME	ORDER
ZAC	1
JEFF	2
BART	3
KATE	4

My goal is to take the numbers in ORDER and reposition them randomly and update that into the table, keeping the NAME records in the same position that they were in originally.

Example of the desired result:

NAME	ORDER
ZAC	3
JEFF	1
BART	4
KATE	2

Using the table above, I have tried the following solutions:

#1

Update TEST_TABLE
Set ORDER = dbms_random.value(1,4);

This resulted in the random numbers between 1 and 4 inclusive, but the numbers could repeat, so ORDER could have the same number multiple times

Example of the attempted solution:

NAME	ORDER
ZAC	3
JEFF	1
BART	3
KATE	2

#2

Update TEST_TABLE
Set ORDER = (Select dbms_random.value(1,4) From dual);

This resulted in the same random number being copied into each ORDER record, so if the number came out at 3, then it would change them all to 3.

Example of the attempted solution:

NAME	ORDER
ZAC	3
JEFF	3
BART	3
KATE	3

This is my first time posting to StackOverflow, and I am relatively new to Oracle, so hopefully I proposed this question properly.