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;
/
，