17,075
社区成员
发帖
与我相关
我的任务
分享
with a as
(select '001' code,1 feature_order, '(' feature_left,'~' feature_right from dual
union all
select '001' code,2 feature_order, '' feature_left,')×' feature_right from dual
union all
select '001' code,3 feature_order, '' feature_left,'' feature_right from dual
union all
select '002' code,1 feature_order, 'φ' feature_left,'×' feature_right from dual
union all
select '002' code,2 feature_order, '' feature_left,'~' feature_right from dual
union all
select '002' code,3 feature_order, 'φ' feature_left,'×' feature_right from dual
union all
select '002' code,4 feature_order, '' feature_left,'' feature_right from dual
union all
select '003' code,1 feature_order, '' feature_left,'^' feature_right from dual
union all
select '003' code,2 feature_order, '' feature_left,' ' feature_right from dual --此处分隔符是空格
union all
select '003' code,3 feature_order, '' feature_left,'^' feature_right from dual
union all
select '003' code,4 feature_order, '' feature_left,'' feature_right from dual
),
b as
(select '001' code,'(30~20)×5' title from dual
union all
select '002' code,'φ2.9×1.78~φ28.17×3.53' title from dual
union all
select '003' code,'18L/桶^GL-4 85W/90^厦工专用' title from dual
)
select a.*,b.* from a,b
where a.code = b.code