Re: Temporary tables in memory using PL/SQL (as a workaround for not having CREATE TABLE privs)?

Are you sure PL/SQL Tables (now known as collections?) will do the job? I thought collections were single-value lists, indexed by an integer, or key-value pairs.

Imagine I have a table with 50 columns (don't imagine whether that's good or bad, just imagine it exists and I need to use it). A singlecolumn  collection won't work. Cursoring through rows to generate INSERT statements, having to specify vcur_TABLE.ROW for each of the 50 columns in a DBMS_OUTPUT.PUT_LINE or UTL_FILE would be tedious.

Or am I wrong about PL/SQL tables/collections in Oracle 9i? Are they not merely lists / associative arrays? Received on Thu Feb 14 2008 - 08:58:46 CST