Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Littymol.
Asked: October 28, 2016 - 5:51 am UTC
Last updated: October 28, 2016 - 8:38 am UTC
Version: 11g
Viewed 1000+ times
create table t ( x varchar2(100) ); insert into t select dbms_random.string('a', 10) from dual connect by level <= 10; select * from t; X rymGBKBuwd EKHxpzrDUy HIuhcZEATc kooiSDxcJx IRroyVLfpE TNVKETYrGU nmjlMXNEaz xAVMnGdGMR dYNonpIMZZ YkPtiUpEsY update t set x = 'OLD' || x; select * from t; X OLDrymGBKBuwd OLDEKHxpzrDUy OLDHIuhcZEATc OLDkooiSDxcJx OLDIRroyVLfpE OLDTNVKETYrGU OLDnmjlMXNEaz OLDxAVMnGdGMR OLDdYNonpIMZZ OLDYkPtiUpEsY
Littymol Jacob, October 28, 2016 - 9:44 am UTC
More on PL/SQL routine DBMS_RANDOM here