Getting started with PL/SQL

I signed up for the Database Design course at my university, the courses are great but the practical laboratories are not, it’s just a bunch of tiresome SQL queries and incomplete instructions. If you too have to do a lot of tiresome SQL queries I suggest the following setup:

  1. Download Docker.
  2. Download any Intellij IDE (if you’re a student you can get it for free). Preferably DataGrip.

After you installed the aforementioned tools you start with a some docker commands:

Instructions here, if you want to explore on your own.

docker pull wnameless/oracle-xe-11g
docker run -d -p 49161:1521 wnameless/oracle-xe-11g

Now, open DataGrip, add a new data source, select Oracle and use the following settings:

hostname: localhost
port: 49161
sid: xe
username: system
password: oracle

Do not bother with the official docker images from Oracle, they usually don’t work.

Thank you for reading!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.