ExportDDL.js in Oracle SQLCL

How to run JavaScript in Oracle SQLcl with Java 17 (thatjeffsmith.com)

1) Install JDK 17

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"

  1. 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