insert into t_c5_one(bgdw,bgr,bkbh,bklb,blfl) SELECT substr(Report_card_no,0,9),
Reporter,Report_card_no,decode(Card_Status,'原始卡','1','订正卡',
Age_unit,Address_code,'0','_','0','0',null,cast(Dead_Last_auditing_timecast as timestamp),"",cast(Fill_in_date as timestamp),Fill_in_doctor,'',
cast(Recently_edit_time as timestamp),decode(Pat_gender,'男','1','女','2'),Borough_Code,'','','0',cast(Confirm_date as timestamp),Id_card,
'' as gldx_id,Address,Address_code,''as zzdbz ,'' as bgjgmc,'' as gljgdm ,'' as gljgmc FROM cdcbuf.T_C5_TWO@zhdata';使用dblink查询出表中的值经过转换插入特定的表中。使用存储过程
Reporter,Report_card_no,decode(Card_Status,'原始卡','1','订正卡',
Age_unit,Address_code,'0','_','0','0',null,cast(Dead_Last_auditing_timecast as timestamp),"",cast(Fill_in_date as timestamp),Fill_in_doctor,'',
cast(Recently_edit_time as timestamp),decode(Pat_gender,'男','1','女','2'),Borough_Code,'','','0',cast(Confirm_date as timestamp),Id_card,
'' as gldx_id,Address,Address_code,''as zzdbz ,'' as bgjgmc,'' as gljgdm ,'' as gljgmc FROM cdcbuf.T_C5_TWO@zhdata';使用dblink查询出表中的值经过转换插入特定的表中。使用存储过程
解决方案 »
- dbms_xmlquery检索结果不完整是怎么回事啊?
- VB.NET 连接Orcale ORA-06413: 连接未打开
- oracle是否能像SQL一樣,在一台服務器下,實現多個數據庫?
- 疑难杂症,高手速进来...怎样将两列合并在一张表?
- 解决问题马上给分?表名,列名作参数
- 监听程序配置报错~~~求助!!!
- windows2000环境下oracle816升级到oracle9i,有什么需要注意的地方?特别欢迎有经验的朋友提供建议
- 请教VB中利用ADO访问远程服务器上的Oracle数据库,Connectiongstring连接字符串怎么写?全分!
- 如何通过自己的oracle存储过程进行按用户模式的数据备份?
- 求救:关于ORA-12545的解决方法
- 请教一个索引的问题:为什么建了索引的表查询还会全表扫描
- 急!!oracle是否可以选择性插入值,
先执行select部分,看错误再哪里。