Notice that the DBMS_RANDOM.STRING function accepts two parameters. In the example, the first parameter “U” limits the output to uppercase letters only, while the second parameter 10 indicates the number of characters to string together.

Vertica doesn’t have a built-in function for it, but it is possible to generate a random string of characters!

First off, it’s relatively easy to produce a single random uppercase letter using the CHR and RANDOMINT functions like this: