欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

ORACLE列值合併

程序员文章站 2022-05-15 19:44:45
...

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;

/

相关标签: ORACLE 列值