For more information on these data types, see your Oracle Rdb documentation. LONG VARCHAR varying-length column for character string data, which has 16,383 characters. LONG VARCHAR is equivalent to ...

The PL/SQL package DBMS_RANDOM can generate random text and date values as well as numbers. Check out these code examples to learn how you can generate these values in your development work.