How to execute a sql file in Docker Oracle 12? How to execute a sql file in Docker Oracle 12? oracle oracle

How to execute a sql file in Docker Oracle 12?


Follow this link to install an Oracle 12c Docker image. I installed it on my Mac.

https://dzone.com/articles/creating-an-oracle-database-docker-image

Download the Oracle Instant Client which includes SQL* Plus.

OR

Download the latest command line tool SQLcl

Now, to run a script you may Connect to your database using the easy connect with sqlplus or sql commandline.

sqlplus user/pwd@//localhost:1521/ORCLPDB1 yourpath/yourscript.sql