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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: miraora
  • Order by date
  1. miraora

    Formating out put and calculating

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

    Formating out put and calculating

    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
  3. miraora

    Formating out put and calculating

    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...
  4. miraora

    HELP:QUERY

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

    HELP:QUERY

    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...
  6. miraora

    HELP:QUERY

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

    HELP:QUERY

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

    HELP:QUERY

    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...
  9. miraora

    HELP:QUERY

    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
  10. miraora

    HELP:QUERY

    Any HINTS Please
  11. miraora

    HELP:QUERY

    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
  12. miraora

    HELP:QUERY

    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...
  13. miraora

    Analytical Function

    Thank you for your help
  14. miraora

    Analytical Function

    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...
  15. miraora

    Rollback Segment

    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]
  16. miraora

    Rollback Segment

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

    PERFOMANCE ISSUE

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

    PERFOMANCE ISSUE

    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 ...
  19. miraora

    PERFOMANCE ISSUE

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

    PERFOMANCE ISSUE

    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.

Part and Inventory Search

Back
Top