Ok, I have created my own datatype called num_tab as a table of numbers.
And now I am creating a function where I go through in a loop and insert
differnet numbers into this table of numbers through a variable called
v_numtab. At the end of my function I have to sum up all the numbers in
this table/variable. That is what I don't know how to do. Normally it is
easy to do because I know the column name, but with this datatype created I
dont know the column name. Does anybody know how to sum everything up from
it. I was thinking select sum(v_numtab) from dual; But that didn't work.
Any ideas would be appreciated. Thanks. Please email me with ideas.
Please send to both email addresses. Thank again.


Jeff Chirco
jchirco (AT) adelphia (DOT) net
jchirco (AT) innout (DOT) com

Jeff Chirco wrote:

Do you mean something like this?

CREATE OR REPLACE TYPE NumTab_t IS TABLE OF NUMBER(5);
/

set serveroutput on

DECLARE

numary NumTab_t;
x PLS_INTEGER := 0;

BEGIN
-- initialize collection
numary := NumTab_t(0);
-- extend the collection to the size of the PL/SQL table
numary.EXTEND(4);

-- for each element in the PL/SQL table
FOR i IN 1 .. 5
LOOP
numary(i) := i;
END LOOP;

-- sum the values
FOR j IN 1 .. numary.COUNT
LOOP
x := x + numary(j);
END LOOP;

dbms_output.put_line('Sum of values = ' || x);
END;
/

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----