导出insert into语句

１、 

统计统一个字段中具有不同的值的个数
select names,count(*) a from counter group by names
select substr(names,1,3),count(*) from counter group by substr(names,1,3)
select substr(names,1,(instr(names,'-',1)-1)),count(*) from counter
group by substr(names,1,(instr(names,'-',1)-1))

２、

导出insert into语句
select 'insert into scott.emp(empno,ename,class)
 values (''' || scott.emp.empno || ''','''||scott.emp.ename || ''',''six'');'
from scott.emp

结果
-----------------------------------------------------------------------
insert into scott.emp(empno,ename,class) values ('7369','SMITH','six');
insert into scott.emp(empno,ename,class) values ('7499','ALLEN','six');
insert into scott.emp(empno,ename,class) values ('7521','WARD','six');
insert into scott.emp(empno,ename,class) values ('7566','JONES','six');
insert into scott.emp(empno,ename,class) values ('7654','MARTIN','six');
insert into scott.emp(empno,ename,class) values ('7698','BLAKE','six');