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?