Download the docker container of the Oracle database with an experimentalsupport for the Multi Language Engine from Oracle Database MLE.

Load the docker image:

Run the container (note that you can also configure non-default credentials,but this tutorial does not do that):

To show only running containers and find out a necessary container ID, use the given command:

You have to wait for the database to start. It may take quite a lot of time forthe first run, next runs are faster.To verify the database has started, run the sqlplus from a new command shell:

sqlplus scott/tiger@localhost:1521/ORCLCDB

Note: scott/tiger are the default login/password.ORCLCDB is a site identifier (SID). There can be more than one database onthe same Oracle_HOME, that is why SID is required to identify them.If you have changed the default login/password, change the command respectively.If works - the database is ready. Exit sqlplus.

mkdir crazyawesome
cd crazyawesome
echo "{}" > package.json

Deploy the validator module to the database, in the following commandvalidator is the module name:

Start sqlplus again:

sqlplus scott/tiger@localhost:1521/ORCLCDB

Use the validator module functions as the stored procedures. Make sure to put a semicolon after the query:

select validator.isEmail('oleg.selaev@oracle.com') from dual;
select validator.isEmail('oleg.selaev') from dual;