19 September 2011
19 September 2011

Bulk Processing in Oracle Part 1

1
As you know (or may not know) there are two engines running in the Oracle database. The PL/SQL engine for executing all your PL/SQL code and the SQL engine for executing all you SQL statements. This means that every time your PL/SQL code needs data from the database, or writes to it control is passed from the PL/SQL runtime engine to the SQL.… Read more
1
02 September 2011
02 September 2011

Collections in Oracle Part 2

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

Working with Table Functions in PL/SQL

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