导出insert into语句

来源:互联网 发布:淘宝买了电动车后悔了 编辑:程序博客网 时间:2024/03/29 19:11

1、 

统计统一个字段中具有不同的值的个数
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))

2、

导出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');

原创粉丝点击