19 August 2011
19 August 2011

Collections in Oracle Part 1

1
“The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of information, very similar to 3GL arrays. Much like ‘in-memory’ tables. Maybe that’s why they started out as PL/SQL Tables. The PL/SQL only version got renamed a couple of times. When first introduced in Oracle 7 they were called PL/SQL tables… Read more
19 August 2011
19 August 2011

Can PL/SQL be Faster than SQL?

1
PL/SQL and SQL both are incredibly powerful languages that allow us to do some pretty amazing things with data. If you’ve been around the Oracle community for some time you’ve probably realized, either through your own experience or by reading articles, if you are able to accomplish a task using a single SQL statement then that is preferred over using… Read more
18 August 2011
18 August 2011

Autonomous Transactions in Oracle

1
Autonomous transactions are a bit like that dark part of the forest, beyond the rickety bridge, where the shadows are shaped like witches and bats swarm soundlessly from the trees. We all know it’s there, but the wise are in no hurry to visit. Here, however, is a definition: an autonomous transaction is a completely independent transaction that is started… Read more
17 August 2011
17 August 2011

My Case for Agile Development, Cary Millsap

0
Cary Millsap (Oracle Ace Director, co-founder of the OakTable) explains how the principles of the Agile Manifesto have defined his most commercially and technically successful projects (specifically, the implementation of the Agile Manifesto called Extreme Programming (XP), as explained by Kent Beck). Watch a full video recording of the session, including the Q+A. … Read more
12 August 2011
12 August 2011

Multi-Language Database Applications using Apex

0
It isn’t straightforward to design a database application that has to provide text data in several languages. There are several problems to overcome such as, for example, allowing the translation bureau to work independently, using their own specialised formats. Fortunately, Oracle Apex can, if you follow the advice in this article, do the hard work for you.… Read more
05 August 2011
05 August 2011

Oracle APEX on your Smartphone

4
Going mobile is one of the hot topics at the moment. Everyone has a  smartphone with internet connection and a browser. Some prefer brand A  against brand B, but that’s just a personal preference. It doesn’t really change a thing. You want to join the crowd and provide a mobile interface for your APEX Application? There’s nothing easier than that!… Read more
20 July 2011
20 July 2011

Working with Table Functions in PL/SQL

9
Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database table. You use a table function like the name of a database table, in the FROM clause of a query. The difference with a physical database table in the FROM clause of the query is… Read more