RE: Random Name Generator

Pieced together from multiple sources.  

select listagg(str, '_') within group (order by str) from (

select str from (

select distinct str from (

with data as (select table_name str from dict where table_name not like '%$%')

select trim(column_value) str

  from data, xmltable(('"' || replace(str, '_', '","') || '"')))

order by dbms_random.value)

where rownum <= 4)

/      

From: post.ethan_at_gmail.com <post.ethan_at_gmail.com> Sent: Saturday, April 13, 2019 8:15 PM
To: 'ORACLE-L' <oracle-l_at_freelists.org> Subject: Random Name Generator  

This should be fairly trivial using some of the data dictionary tables to parse words from.  

https://github.com/moby/moby/blob/master/pkg/namesgenerator/names-generator.go  

Anyone know if an Oracle function exists out there that does something like this before I end up writing one?  

Which DBA_|USER_|tables/v$views would end up returning the most English-y sounding words to pull from? I don’t want to seed a look up table, just use what is already here.  

If you have time to write it I will be posting an open-source PLSQL package of tools 😊 in a week or so and will include it (or a version of it and give you credit). This will be a work in progress. I have a lot in the queue and will take me some time to get it all out there.  

Made my first PDB tonight! Hah, give me the Eagles, Boston and Oracle 11 no-rac -here any day of the week. Been two years since I wrote any SQL!  

Thanks!  

Ethan Ray Post

--
http://www.freelists.org/webpage/oracle-l