Skip to content

Instantly share code, notes, and snippets.

@uzbekdev1

uzbekdev1/orcl.sql

Created October 17, 2021 20:20
Show Gist options
  • Save uzbekdev1/6cb3e8edeb685336e5097e0f18fcb687 to your computer and use it in GitHub Desktop.
Save uzbekdev1/6cb3e8edeb685336e5097e0f18fcb687 to your computer and use it in GitHub Desktop.
Download ZIP
oracle random string
Raw
orcl.sql
/*
U - Upper case
L - Lower case
A - Alphanumeric
X - Alphanumeric with upper case alphabets.
P - Printable characters only
*/
select
dbms_random.string('L', 20),
dbms_random.string('U', 20) ,
dbms_random.value(1,1000) ,
dbms_random.string('A', 20) ,
dbms_random.string('X', 20),
dbms_random.string('P', 20),
dbms_random.random
from dual
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment