/plsql

Exercism exercises in PL/SQL.

Primary LanguagePLSQLMIT LicenseMIT

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