sql语句如下
insert into tb_customer_info(id,CUSTOMER_NAME,system_customer_no,CUSTOMER_TYPE)
select
TAX_SEQUENCE.NEXTVAL,
a.CUSTOMER_NAME,
a.system_customer_no,
3 from(select
fund.sys_code||'虚拟客户' as CUSTOMER_NAME,
'XN'||fund.sys_code as system_customer_no
from tb_output_fund_product fund
where fund.fundraising_channel='3'
and 'XN'||fund.sys_code not in
(select cust.system_customer_no from tb_customer_info cust))a;在存储过程报错,在sql窗口正常执行
insert into tb_customer_info(id,CUSTOMER_NAME,system_customer_no,CUSTOMER_TYPE)
select
TAX_SEQUENCE.NEXTVAL,
a.CUSTOMER_NAME,
a.system_customer_no,
3 from(select
fund.sys_code||'虚拟客户' as CUSTOMER_NAME,
'XN'||fund.sys_code as system_customer_no
from tb_output_fund_product fund
where fund.fundraising_channel='3'
and 'XN'||fund.sys_code not in
(select cust.system_customer_no from tb_customer_info cust))a;在存储过程报错,在sql窗口正常执行
解决方案 »
- 紧急求助~ORA-01033: ORACLE initialization or shutdown in progress
- oracle问题求教
- Lucene Larm 源代码和怎么使用
- linux环境里,oracle安装好后,怎样写脚本,实现chkconfig管理下的"服务"啊
- 书上说定义全局数据库名时, 要按照数据库.域名称,请问这里的域名称是指网络的域名称还是可以自己随便定义的.
- 如何写这个存储过程???
- 实验:关于LOB(LOB表的建立,存储,DBMS_LOB的一些初步学习)
- 菜鸟请教!
- plsql连接oracle疑难杂症求帮助
- --oracle 外部块标签 执行报错,是语句结构有问题吗?
- 在线急等!读取CLOB字段,字符串缓冲区太小,怎么解决?
- 静默安装oracle11.2.0 sqlplus 报错
这个结果,有重复的。建议查一下
对这一列group by,发现条数是一样的,说明不存在重复结果。。
DBMS函数可以