SQL> select dbms_random.string('l', 8)||'@'||dbms_random.string('l', 7)||'.com'
email from dual;
EMAIL
------------------------------------------------------------------------------------
irslsxrf@wltikyv.com
The first parameter 'l' means string will be created in lower cases.
This blog is mostly focused on the technical aspect of data mining.
Tuesday, December 18, 2018
Generate Random String in Oracle
The following query generate random email address.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment