Re: Random Name Generator

Have a look at random ninja packages from Morten Eagan. Available on github.
https://github.com/morten-egan

Morten spent a lot of time on it an created a whole set of data generators for testing.

On Sun, 14 Apr 2019, 05:00 , <post.ethan_at_gmail.com> wrote:

> 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