I'm trying to update a column in a table, with about 1000 rows, with a randon string.
This is what i tried....
update tab1 set col1 = (select dbms_random.string('X', 5) from dual)
This doesnt seem to work.. its not getting a new random number.
Is there a simple solution.
Appreciate your time.