Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
displaying more than one elements in an array.
I guess, you have to put "display" in decremental loop,once you assign all values to array. You must be having high value for loop increment variable,once you finish assigning values to array.So only you should you reverse loop( decremental loop) for "display" your array...- gonela
- Post #2
- Forum: Data Warehousing/Big Data
-
select distinct MONTH_NBR MONTH,sum
select distinct MONTH_NBR MONTH,sum(nvl(VALUE_NBR,0)) TOTVAL FROM ( select c.time_id,c.VALUE_NBR VALUE_NBR from tab1 a,tab2 c where a.r_id=c.r_id and (a.descr like '%Count') ) z, timedim b WHERE b.TIME_ID=z.TIME_ID(+) GROUP BY MONTH_NBR Output we're gettng for the above query (...- gonela
- Thread
- Replies: 0
- Forum: Data Warehousing/Big Data
