ORACLE列值合併

来源：懂视网责编：小采时间：2020-11-09 13:40:09

ORACLE列值合併

ORACLE列值合併: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 d

推荐度：

点击下载本文 文档为doc格式

导读ORACLE列值合併: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 d

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

COMMIT;

，

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com