Last week, I wrote about how to use
bash arrays and the MySQL
database to create unit and integration test scripts. While
the MySQL example was nice for some users, there were some others
who wanted me to show how to write
scripts for Oracle unit and integration testing. That’s what this
blog post does.
If you don’t know much about
bash shell, you should
start with the prior post to learn about bash arrays,
if-statements, and for-loops. In this blog post I only cover how
to implement a
bash shell script that runs SQL
scripts in silent mode and then queries the database in
silent mode and writes the output to an external file.
I’ve copied the basic ERD for the example because of a request from a reader. In their opinion it makes cross referencing the …[Read more]