oracle - Oracle7:Merge data are same in many records to one record -


I would like to merge the data into one record in many records. From FO Line Foror Color SUM S4714EH02 EH11FA 9S 4714EH02H 11FA 18S 4714EH02HEFFE 9S 4714EH2EH11FFE 18S 4714EH 02 AH 12 FA 9S 4771 EH 02 AH12 FA 18S 4771 EH 02 AH12FF9 S4714EH02 EH12FFE 18 

  FO line floor color SU 4714Eh02h 11f 9,18 S 4714 EH 0F11FFE 918S S 4714EH02H AH12F AK 9,18S 4714EH02H 12FFE 9, 18   
 I know that It may be in SQL Server 2008 but I do not know whether it The Ekl create 7. Please help me. Thank you  
  
 
 
 The APC has already said very well, this version is really old and all types I have worked with version 7 in the last 7 years, and I think the next sequence should work in Oracle7. Although I may be wrong, but obviously I can not investigate it.  
  SQL & gt; 2 of 3 Selection 'S4714EH02', 'AH', '11f ',' A ', 9 Dual Union Select Table T (FO, Line, Floor, Color, Yoga) as 9' S 4714 EH 02 18, all 5 selected 'S 4714 EH 02', 'EH', '11F ',' EF ', 9 from Dual Union, all six selections from' EH ', '11F', 'A', Dual Union, S 4714 EH 02 ',' EH ', '11 F', 'EF', Dual Union 7 All 7 Selections 'S 4714 EH 02', 'EH', '12F', 'A', 9 Dual Union 9 All 8 Selection 'S 4714 EH 02', 'EH', '12 F', 'A', all 9 selections from Dual Union 'S4714EH02', 'EH', '12 F ',' EF ', 9 from Dual Union All 10 Selections' Number 4714 EH 02 'EH', 12 'F', 'EF', 18 II went created 11 / table SQL & gt; Return varchar2 7 8 Cursor C9 is Function F2 (P_FO T.F.O. Type3, T. Line% Type 4, P_Fluure T.Flur% Type 5, PGLLOR T.T.LOR% Type 6). 10 is selected from t.sum 11 to t12 where t.fo = p_fo 13 and t.line = p_line 14 and t.floor = p_floor 15 and t.color = p_color 16 order t.sum 17; 18 l_concatenated_sum varchar2 (2000); Start 19 in 21 R22 for R20 l_concatenated_sum: = l_concatenated_sum || ',' || TO_CHAR (r.sum); 23 & Loop; 24 return substrate (l_concatenated_sum, 2); 25 end F; 26 / Function created SQL & gt; F8, line 3, floor 4, color 5, f (foy, line, floor, color) for 6 zones from T7 group for F8, Line 9, floor 10, Color 11 / FO La FLO CO Sham - Select. ------- --- - -------------------- S4714EH02EAH11 FA918S S 4714EH2EH11FFE 918S S 4714 EH 02 AH 12 F.A. 9, 18 S 47714 EH 02 AH12FFE 9, 18 4 rows were selected.   
 Regards, 
 Rob

Comments

Post a Comment