Infrastructure at your Service

PL/SQL Archives - Blog dbi services

Alain Lacour

APEX Connect 2017 – Day 1

By | Development & Performance | No Comments

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by Bryn Llewellyn I decided to attend presentations on following topics: – Temporal Validity and Flashback Data Archive – Universal Theme and Custom Themes in APEX 5.1 – Using REST Services in APEX applications the nice way…

Read More
Daniel Westermann

How to destroy your performance: PL/SQL vs SQL

By | Database Administration & Monitoring | No Comments

Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing it in PL/SQL. This was a very good example for myself to remind me to check the documentation and to verify if what I believed a feature does is really what the feature is actually…

Read More
Daniel Westermann

Fun with PL/SQL code reviews – Part 1

By | Database Administration & Monitoring | No Comments

For quite a long time I did not work anymore with PL/SQL and was quite happy when I had the chance to review some code at a customer. The status today: I am not that happy anymore Let me explain why and show you some examples on what was discovered. Of course all of the identifiers have been obfuscated and this is not to blame anyone. It is more to make people aware of what…

Read More
Alain Lacour

APEX Connect 2016 – Day 1 – SQL and PL/SQL

By | Development & Performance | No Comments

This year the APEX connect conference spans over three days with the first day dedicated to SQL and PL/SQL which are the basement of APEX and its close link to the Database. After the Keynote about “Six months of ask Tom” by Chris Saxon who is filling in for Tom Kyte on the famous “Ask Tom” website I decided to attend presentations on following topics: – A Primer on Service Workers – Managing the changes…

Read More
Daniel Westermann

When a function returns a collection: can you directly reference the index of the returned collection?

By | Database Administration & Monitoring | One Comment

As I am still interested in PLSQL I browsed the documentation some days ago and learned something new which is about functions returning collections. Here is a simple test case: Let’s create a simple package, specifying on collection and one function: create or replace package pkg1 as type t1 is table of number index by pls_integer; function f1 ( a number ) return t1; end pkg1; / create or replace package body pkg1 as function…

Read More
Pierre Sicot

UKOUG Day 3: PL/SQL hints by Tom Kyte & Oracle Active Data Guard

By | Technology Survey | No Comments

Today’s first session I assisted was presented by Tom Kyte. He talked about SQL topics we surely do not know. The first topic concerned the possibility of using the plsql_warning clause with the PL/SQL compiler. This feature exists since version 10.1 but is not widely used. The different values you can define for the plsql_warning with a classical alter session command are: Severe: code might cause unexpected errors or wrong results Performance: code might cause…

Read More
Arnaud Berbier

Oracle Open World 2013: Day four – Oracle APEX 5.0 and new development techniques

By | Technology Survey | One Comment

This session of John Snyders, Principal member of Technical Staff, Oracle, discussed som new functionalities which will be integrated in the next major release of Oracle APEX – APEX 5.0. The goal of this new release is to improve developer productivity. The way to improve it is to provide out-of-box modal dialog, navigation list, CSS Calendar, and multi-row edition. The most important new features will be the enhancement of the application builder in order to…

Read More
Nicolas Jardot

Oracle Open World 2013: Final day – Database as a service and replication fundamentals

By | Technology Survey | No Comments

My final day at Oracle OpenWorld 2013, less sessions and less people but still a big day after almost one week in San Francisco. In this blog I’ll focus on the private cloud with databases as service and the fundamentals about replication. To conclude on Oracle OpenWorld, I would say that there are three big news – more on these at the end of this posting. On Thursday, there are less people in the sessions…

Read More
Nicolas Jardot

OakTable at UKOUG 2012: Hybrid Columnar Compression (Exadata), SQL tuning, etc.

By | Technology Survey | No Comments

Yesterday, I went to a set of sessions organized by OakTable members just before the kick-off of the UKOUG conference 2012, one of the biggest events on Oracle Technology and E-Business in Europe. This post focuses on some of the covered topics, such as database development, Hybrid Columnar Compression (Exadata), optimizer statistics, and SQL tuning. There were 2 streams with very interesting topics. I attended to sessions covering the following topics: Application development: Keep it…

Read More