Advertisement
| Hall of Fame |
- 1. sdstuber538,695
- 2. mrjoltcola229,274
- 3. angelIII192,080
- 4. Andytw154,708
- 5. schwertner93,609
- 6. HainKurt86,983
- 7. Milleniuma...86,559
- 8. awking0078,888
- 9. sujith8072,357
- 10. shru_0...70,276
- 11. rrjegan1767,920
- 12. flow0166,359
- 13. johnsone57,059
- 14. lwadwell56,875
- 15. mwvisa142,140
- 16. markgeer39,942
- 17. gatorvip38,324
- 18. MarkusId37,180
- 19. MikeOM_...34,998
- 20. ajexpert34,492
- 21. nav_kum_v34,215
- 22. aneeshatti...31,000
- 23. Sharath_...30,245
- 24. it-rex29,936
- 25. slightwv29,200
- 1. sdstuber1,281,848
- 2. angelIII625,044
- 3. sujith80455,241
- 4. schwertner243,623
- 5. mrjoltcola229,274
- 6. nav_kum_v203,534
- 7. jinesh_ka...179,836
- 8. awking00173,120
- 9. Andytw154,708
- 10. johnsone140,492
- 11. Milleniuma...131,103
- 12. MikeOM_...126,129
- 13. markgeer123,908
- 14. jwahl98,255
- 15. DrSQL96,094
- 16. sonicefu87,105
- 17. HainKurt86,983
- 18. slightwv83,675
- 19. ajexpert82,877
- 20. ishando80,333
- 21. shajukg79,793
- 22. flow0174,319
- 23. shru_0...70,276
- 24. YANN0S68,787
- 25. gatorvip68,102
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Weird sorting problem. Good question.
Asked by mathieu_cupryk in PL / SQL, Oracle Database, Oracle 10.x
No.1 Canada Western Amber Durum Ac
should come after
No.1 Canada Western Amber Durum Ac Strongfield
Please see attached file.
Why does the following oracle statement does not order it properly.
PROCEDURE get_Grades (cur_out IN OUT t_cursor,
p_price_list_hdr_id IN price_list_dtl.price_list_
p_status OUT NOCOPY varchar2)
-- for the Grade Codes spreadsheet
IS
BEGIN
p_status := 'Success';
OPEN cur_out
FOR
-- ALL 4 GRAINS
SELECT C.grade_pool_code, C.grain_class_name, C.grade_protein_pct, B.strght_price_amt - A.old_price_amt delta_price,
D.strght_code, B.strght_price_amt, D.tough_code, D.damp_code, D.stone_code, D.tough_stone_code, D.damp_stone_code, G.sct_effctv_dtm,
G.pool_part_code
FROM (select E.grade_code_dtl_id, max(e.strght_price_amt) old_price_amt
FROM price_list_dtl E, price_list_hdr F
WHERE F.price_list_hdr_id = F.price_list_hdr_id
-- AND F.price_list_status_type_n
-- AND F.load_type_name in ('Initial','Adjustment')
-- and e.price_list_hdr_id < p_price_list_hdr_id
and e.price_list_hdr_id = p_price_list_hdr_id
GROUP BY e.grade_code_dtl_id) A, price_list_dtl B, grade_code_dtl C, price_list_hdr G,
(Select grade_code_dtl_id,
max(CASE code_type_name when 'STRAIGHT' then disc_code else null end) as Strght_Code,
max(CASE code_type_name when 'TOUGH' then disc_code else null end) as Tough_Code,
max(CASE code_type_name when 'DAMP' then disc_code else null end) as Damp_Code,
max(CASE code_type_name when 'STONE' then disc_code else null end) as Stone_Code,
max(CASE code_type_name when 'TOUGH STONE' then disc_code else null end) as Tough_Stone_Code,
max(CASE code_type_name when 'DAMP STONE' then disc_code else null end) as Damp_Stone_Code
from grade_item
group by grade_code_dtl_id) D
WHERE B.price_list_hdr_id = p_price_list_hdr_id
AND C.grade_code_dtl_id = B.grade_code_dtl_id
AND A.grade_code_dtl_id = C.grade_code_dtl_id
AND D.grade_code_dtl_id = C.grade_code_dtl_id
AND G.price_list_hdr_id = b.price_list_hdr_id
ORDER BY grade_pool_code,grade_name
EXCEPTION
WHEN OTHERS THEN
p_status := 'Failure: ' || SQLERRM;
END get_Grades;
