Oracle dbms_random package can generate random characters in character, numeric or alphanumeric formats. <\/p>\n
dbms_random.value(Parameter, Value)<\/p>\n
Create Random Characters<\/strong><\/p>\n \nSQL> select dbms_random.random value from dual; SQL> select dbms_random.value from dual; SQL> select dbms_random.value(100,1000) valuefrom dual; SQL> select dbms_random.value(100000000000, 999999999999) value from dual; SQL> select dbms_random.string(‘U’, 10) str from dual; SQL> select dbms_random.string(‘L’, 10) str from dual; SQL> select dbms_random.string(‘A’, 10) str from dual; SQL> select dbms_random.string(‘X’, 10) str from dual; SQL> select dbms_random.string(‘P’, 10) str from dual; Oracle dbms_random package can generate random characters in character, numeric or alphanumeric formats. dbms_random.value(Parameter, Value) U – Upper case L – Lower case A – Alphanumeric X – Alphanumeric with upper case alphabets. P – Printable characters only. Create Random Characters SQL> select dbms_random.random value from dual; Value : 531879542 SQL> select dbms_random.value from dual;…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12,6],"tags":[14,90,32],"class_list":["post-664","post","type-post","status-publish","format-standard","hentry","category-oracle-procedure","category-oracle-sql","tag-database-administration","tag-oracle","tag-oracle-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-aI","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=664"}],"version-history":[{"count":6,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/664\/revisions"}],"predecessor-version":[{"id":670,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/664\/revisions\/670"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nValue : 531879542<\/p>\n
\nValue : 1<\/p>\n
\nValue : 452<\/p>\n
\nValue : 515055428760<\/p>\n
\nValue : KGSQLEKTSX<\/p>\n
\nValue = ksfkwqwerv<\/p>\n
\nValue : RhjE+RojjL<\/p>\n
\nValue : GF:E3B4GRB<\/p>\n
\nValue : *Yw(IK\/zsj\n<\/p><\/blockquote>\n
\nDBMS_RANDOM is a good utility and will find its way into lot of development projects, especially web based ones. However, this Package is not exhaustively documented. One should not use it just for the sake of it being there. Make sure that there is a true requirement or a necessity of random values before making use of this package. If you already have a custom code meant for the same purpose, check out the benefits that are available when using this package compared to your application.<\/p>\n","protected":false},"excerpt":{"rendered":"