Sha256: 65d50f61f7c61ac2fee0d8e83e5cb8c4cefd5ff5502fafe706760c5698d857f0

Contents?: true

Size: 1.82 KB

Versions: 215

Compression:

Stored size: 1.82 KB

Contents

# xPL/SQL

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](https://github.com/exercism/x-api/blob/master/CONTRIBUTING.md#the-exercise-data)

Version data entries

215 entries across 215 versions & 1 rubygems

Version Path
trackler-2.2.1.180 tracks/plsql/README.md
trackler-2.2.1.179 tracks/plsql/README.md
trackler-2.2.1.178 tracks/plsql/README.md
trackler-2.2.1.177 tracks/plsql/README.md
trackler-2.2.1.176 tracks/plsql/README.md
trackler-2.2.1.175 tracks/plsql/README.md
trackler-2.2.1.174 tracks/plsql/README.md
trackler-2.2.1.173 tracks/plsql/README.md
trackler-2.2.1.172 tracks/plsql/README.md
trackler-2.2.1.171 tracks/plsql/README.md
trackler-2.2.1.170 tracks/plsql/README.md
trackler-2.2.1.169 tracks/plsql/README.md
trackler-2.2.1.167 tracks/plsql/README.md
trackler-2.2.1.166 tracks/plsql/README.md
trackler-2.2.1.165 tracks/plsql/README.md
trackler-2.2.1.164 tracks/plsql/README.md
trackler-2.2.1.163 tracks/plsql/README.md
trackler-2.2.1.162 tracks/plsql/README.md
trackler-2.2.1.161 tracks/plsql/README.md
trackler-2.2.1.160 tracks/plsql/README.md