Search notes:

SQLcl: SCRIPT

Execute a script in a file. No suffix is given, therefore SQLcl assumes the script to have a .js suffix (i. e. print-report.js):

SQL> script print-report

The suffix can be explicitely stated:

SQL> script print-report.js

It's possible to run an «ad-hoc» script which must be terminated with a slash on a single line:

hello worldSQL> script
  2  ctx.write('hello world\n');
  3* /
hello world

See also