CREATE TABLE MyTest(xType NUMBER,City nvarchar2(200)); / INSERT INTO MyTest(xType,City) SELECT 1,N’北京’ FROM dual UNION ALL SELECT 1,N’上海’ FROM dual UNION ALL SELECT 1,N’广州’ FROM dual UNION ALL SELECT 2,N’武汉’ FROM dual UNION ALL SEL
CREATE TABLE MyTest(xType NUMBER,City nvarchar2(200));
/
INSERT INTO MyTest(xType,City)
SELECT 1,N’北京’ FROM dual UNION ALL
SELECT 1,N’上海’ FROM dual UNION ALL
SELECT 1,N’广州’ FROM dual UNION ALL
SELECT 2,N’武汉’ FROM dual UNION ALL
SELECT 2,N’杭州’ FROM dual UNION ALL
SELECT 2,N’厦门’ FROM dual
COMMI
本文来源gao!%daima.com搞$代*!码$网9
T;
/
，
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：ORACLE列值合併
转载请注明原文链接：ORACLE列值合併
