Exercism PL/SQL Track
Exercism exercises in Oracle PL/SQL
Setup
You'll need access to a mounted Oracle DB. If you don't have one already installed, here are a few options:
- download VirtualBox from Oracle and run one of the freely available images; at the time of writing, the easiest to get started with at the time of writing might be Database App Development VM. The image is quite large...
- download and install the a version of the Oracle DB itself. Developer licenses are free.
- get a free workspace at https://apex.oracle.com
Note: if you're using the online version of APEX, compilation errors will
not be indicated very clearly when working in SQL Commands - you will simply
get "Error at line XX: PL/SQL: Statement ignored"... More insight can be
found using the Object Browser and navigating to the object you created
(select either Packages or Procedures in the dropdown menu showing Tables,
depending on what you created for the exercise). Also, when you run statements,
"run" each individual create statement individually by selecting its text.
APEX does not seem to like doing too much work at once...
To work on individual problems, a nice and free way is to use SQL Developer. If you don't want to use yet another IDE, you can simply copy and paste your code into a terminal / command prompt connected to the database. The files are prepared in a way that will simply overwrite the previously compiled version.
Style Guide
You will most likely find the formatting used a bit weird at first. If you can, you will find it makes your life much easier over time...
Tests
The last part of both the test file is commented-out code will launch the tests. Simply uncomment and execute.
Contributing Guide
Please see the contributing guide