Total length

Hi all,

I have a query that looks like this:

select length((col1)||') '||upper(col2)||' '||upper(col3)||' '||
upper(col4)||' '||col5||chr(11))

FROM table1, table2

It returns the following results:

24
27
43
53
28

I need to get the total of all these numbers. How can I accomplish that?

How about using SUM()

select SUM(TO_NUMBER(
length((col1)||') '||upper(col2)||' '||upper(col3)||' '||
upper(col4)||' '||col5||chr(11))
))
FROM table1, table2