02 September 2011
02 September 2011

Collections in Oracle Part 2

0
0
“The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This article follows on from Collections in Oracle Part 1 Varray The syntax for defining a varray in SQL is like this: CREATE OR REPLACE TYPE varray_type AS VARRAY(SIZE) OF element_type; The syntax for defining a varray in PL/SQL is lik… Read more
19 August 2011
19 August 2011

Mastering Oracle Trace Data

0
0
A one-day course taught by Cary Millsap London, UK, 8 Sept 2011 Oracle trace data is an extraordinarily rich information source for database application developers, administrators, and anyone who cares about the speed of an Oracle Database application. Oracle trace files include information that yields value throughout your software life cycle, whether you’ve bought prebuilt applications or built them yourself… Read more
19 August 2011
19 August 2011

Collections in Oracle Part 1

0
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?

0
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

0
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
20 July 2011
20 July 2011

Working with Table Functions in PL/SQL

0
14
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