Re: Vector needed

Found I can do this by using a PL/SQL table. The newer Oracle versions allow each column to be a row full of data.

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:QQ0h6.917$zf4.125326_at_newshog.newsread.com...
> I have a cursor which retrieves rows with a group by clause. So in the
> cursor I have sets of rows, lets say ten sets at 13 rows each for 130
 rows.
> I step through the cursor row by row and use the data to fill a global
> temporary table.
>
> Every once in awhile, due to user error, one of the groups will have only
 12
> rows. I need a way to locate the "missing" row and to insert a dummy with
> some label say "MISSING". A vector of the rows would be ideal. Any
 advice
> on the best way to simulate a vector in PL/SQL?
>
> Van
>
>
Received on Sat Feb 10 2001 - 20:15:14 CST