Category Archives: Oracle

PLSQL: Nice little overview of the PL/SQL language

I just came over these slides and nice little overview of the PL/SQL language by Morten Braten. The slides covers many good tips to follow when coding PL/SQL. It’s not ment to be an introduction to the PL/SQL language, so many topics are just mention briefly and would need to be followed by further reading and/or […]

Java and JDBC for Oracle DBAs – Part 5: Spring-Boot, JdbcTemplate & DB migration (Using FlywayDB)

Today we’ll be looking at Spring-boot and a tools which developers use to migrate databases, FlywayDB. We’ll also look at how you can automate grants towards our two roles (which we created in part 3) whenever new tables are created. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java (JDK), Eclipse and Maven […]

Java and JDBC for Oracle DBAs – Part 4: Your first JDBC Application

This is the fourth blog in this blog series which I have called “Java & JDBC for Oracle DBAs”. Now we are finally ready to start to develop towards the Oracle database we created in part 1, and schemas we created in part 3. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java […]

Java and JDBC for Oracle DBAs – Part 3: Git, Oracle schemas and your first Java application

Finally we have come to the point where we start to create some Java code. First we’ll install Git, the most widely used modern version control system. We’ll continue to download some code from GitHub to create our Oracle schemas, and then we’ll create a very simple – but our first – Java application. We’ll […]

Java and JDBC for Oracle DBAs – Part 2: Java, Eclipse, Maven & JDBC

Today I’ll continue with my series on creating an Java and JDBC test application for Oracle DBAs. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java (JDK), Eclipse and Maven (this) Part 3: Git, Oracle schemas and your first Java application Part 4: Your first JDBC Application Part 5: Spring-boot, JdbcTemplate & DB migration […]

Java and JDBC for Oracle DBAs – Part 1: Oracle Database in Docker

Working together with Java developers I sometimes have to test aspects of the JDBC programming. When cooperating with the Java developers it is also very convenient to know some Java. In this blog series I’ll describe how you can build your own Java test application, and how you can get a little more acquainted with […]

Scripts: Tanel Poder´s TPT script out on GitHub

Tanel Poder have uploaded his TPT script to GitHub. If you have never looked as his script I highly recommend spending some time on them. You’ll find them at: https://github.com/tanelpoder/tpt-oracle

OUGN Bergen Spring Seminar 2018

Now you can download the slides from the OUGN Bergen spring seminar at Bergen Media City the 31st of May 2018. “Databasen i skyen – eksterne tabeller: Hvordan løser vi dette da?” m/Lars Johan Ulveseth, EVRY “The cost of idling” m/Espen Vinnes, RightGroup “Kafka & KSQL” m/Bjarte Brandt, TV2 “Kubernetes” m/Bjarte Brandt, TV2