Generating User DDL in SQLcl

Generating User DDL in SQLcl

How to get Oracle SQLcl to generate the DDL for an Oracle USER account.

Copy and paste this URL into your WordPress site to embed

<blockquote class="wp-embedded-content" data-secret="t4GselXL8R"><a href="https://www.thatjeffsmith.com/archive/2019/02/generating-user-ddl-in-sqlcl/">Generating User DDL in SQLcl</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.thatjeffsmith.com/archive/2019/02/generating-user-ddl-in-sqlcl/embed/#?secret=t4GselXL8R" width="600" height="400" title="&#8220;Generating User DDL in SQLcl&#8221; &#8212; ThatJeffSmith" data-secret="t4GselXL8R" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
/* ]]> */
</script>

Copy and paste this code into your site to embed