mercredi 5 mai 2021

oracle: using dbms.random for randomizing characters and numbers

I need help on how I can fully randomize the characters and numbers in the address without affecting the spaces. I tried the query below(PICTURE1) but it replaces all characters into 1 random character only.

enter image description here

RESULT NEEDED SAMPLE ONLY:(random numbers and letters) enter image description here




Aucun commentaire:

Enregistrer un commentaire