ExportDDL.js in Oracle SQLCL
How to run JavaScript in Oracle SQLcl with Java 17 (thatjeffsmith.com)
2) Install GraalVM for JDK 17
3) download Oracle GraalVM Downloads plugins
gu -L install icu4j-installable-jdk-17-windows-amd64-23.0.3.jar
gu -L install regex-installable-jdk-17-windows-amd64-23.0.3.jar
gu -L install js-installable-jdk-17-windows-amd64-23.0.3.jar
setx -m PATH "C:\Program Files\oracle\sqlcl\bin%PATH%";
setx /M JAVA_HOME "C:\Program Files\Java\GraalVM"
- download latest sqlcl
Set always before starting sql this:
set JAVA_HOME=C:\Program Files\Java\GraalVM
sql xys/****@host:1521/pdb
show java
script
ctx.write("Hello");
/
and now Grab exportDDL.js from github repo:
change what you want and:
export an Oracle schema DDL with SQLcl · GitHub
script ...\exportDDL.js