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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gonela

    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...
  2. gonela

    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 (...

Part and Inventory Search

Back
Top