SELECT plant,XPATH,x1,x2,x3,x4,x5,x6,to_char(cdate,'yyyy/mm/dd') cdate,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,p0a,p1a,1,p2a,p3a,p4a,p5a,p6a FROM ( SELECT DISTINCT 'ds' plant,XPATH,x1,x2, x3, x4, x5,x6,cdate, p0a, p1a, p2a, p3a, p4a, p5a, p6a,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12