Anyone who remembers The Ramones will have happy memories of their toetappingly monolithic slabs of pure punk pop. After a couple of albums of two-chord magic, however, there were those who said it was starting to sound samey, and I believe it was Joey Ramone's dad who commented in an interview that perhaps the boys might want to "complicate it up a bit".
It seems the authors of Oracle Database 10g PL/SQL Programming (Oracle Press, 2004) chose to follow similar advice in their chapter on working with 8i, er, I mean 10g collections. Anyone looking for a funkier way to DELETE FROM addresses WHERE address_id = 11, for example, need look no further:
And while we're at it,
SELECT column_value FROM THE (SELECT CAST(emp_address AS varray_nested_table ) FROM emp WHERE empno = 11);
(love that type name btw) could also be written as
SELECT column_value FROM emp, TABLE(emp_address) WHERE empno = 11;
but where's the fun in that?