Search results for query: *

Thank you I go the solution, {tot=$3+$4+$5<b>}</b> qtr_tot=qtr_tot+tot <b>{</b>printf"%-20s\t%s\t%4.2f\t%4.2f\t%3.2f\t%3.2f\n",$1,$2,$3,$4,$5,tot} I chaged to {tot=$3+$4+$5 qtr_tot=qtr_tot+tot printf"%-20s\t%s\t%4.2f\t%4.2f\t%3.2f\t%3.2f\n",$1,$2,$3,$4,$5,tot} Please can...

Hello Thank you for your reply. I run this at prompt like this nawk -f nawk_a.sc doit1 I keep getting extra line, I don't know why. Thank you for your help once again

Hello I am new to Shell Scripting SUN OS 5.9 I want out put in this format ***CAMPAIGN 1998 CONTRIBUTIONS*** --------------------------------------------------------------------------- NAME PHONE Jan | Feb | Mar | Total Donated...

Yes Yes You Got it That was Great. Finally I got the Result. Thank you So MuUch For your Help and Time

Thank You Dragon. Sorry for the format of the code. I tried to post promperly formated code. Some how it misarranges again. I changed the Opportunity_rating to next_op_rating but now it is giving me 3.6667 which is 44/12 Suppose to be 44/22. Also I have to use next_op_rating desc becuase it...

I made some changes and it is giving me correct result till Total 117>>> that is 0.8034. after that it is not giving me correct result. It is adding 117+12 and the dividing so instead of .0909, it is giving me 0.3411 select sku, store_num, year_week_key, end_of_week_on_hand...

Thank you for help. But it is not giving me the correct result.

Thank you once again There is composite key od SKU, STORE_NUM, and YEAR_WEEK_KEY. for one SKU and STORE_num there will be at least 15 to 17 UNIQUE YEAR_WEEK_KEY. so oppertunity_rating is calculated in reverse as it is desending in the query. It start adding untill finds first not_null value of...

Thank you for your response. The values you see in the opportunity_rating is null. Is there any way i can get that result of running total. which I explained as above

Any HINTS Please

I was out of job for a while. I got bcak to oracel field. So i am really confused. I B>S in Electronics SO I need GURUS help. Thank you

Please look at the query. My requirement is to add the distributed sales untill opportunity rating is found not null. As soon as it finds opportunity rating take that total and devide end_of_week_on_hand by the total. and reset that total and start adding again till another oppertunity rating...

Thank you for your help

Hello Masters; I have confusion. I have gone through many documnetation but still not clear how the ranks are decided. In the following code. How eight is given rank as 1, not nine, same as five is given rank two instead of seven. So i would like to know how this ranks are decide. i know the...

Yes Mufasa Great answer. I got my answer. I had a same idea but I was not clear. Thank you so much for your help. [peace]

Hello GURUS Can any one explain why is this used? in procedures and functions Set Transaction Use Rollback Segment RBSHUGE

Thank you so much. I really got a great reply from you. All my dought are clear You are the best[peace]

Thank you LKBrwnDBA for you reply. It is working fine with ROWID. It is faster now. But If use FOR UPDATE it becomes slower by two seconds for 1000 rows. If i don't use this clause should not effect my update(data integrity) as I am not using where CURRENT of CLAUSE in cursor. Am i right ...

Please reply to my last two postings. Thank you in advance

UPDATE: The above procedure is running 1 sec faster then with ROWID, I thought with ROWID would run faster. Just for your consideration. Please let me know what could be the reason.