SELECT (SELECT t.tqmc FROM dw_tq t WHERE t.tqbs=b.tqbs) 第一处,(SELECT y.mc FROM dw_yxbyq y WHERE y.tqbs=b.tqbs) 第二处
FROM fw_kfgdxx a,fw_tsywfjxx b
WHERE a.kfgzdbs=b.kfgzdbs
AND a.kfgzdbh='123456789000000'
FROM fw_kfgdxx a,fw_tsywfjxx b
WHERE a.kfgzdbs=b.kfgzdbs
AND a.kfgzdbh='123456789000000'
解决方案 »
- 关于oracle冷备份的问题!!!!!!!!!!!!!!
- oracle portal 高手请进,帮忙解决一个问题。
- TNS: 监听程序在 CONNECT_DATA中未获得 SERVICE_NAME
- Oracle数据导入问题,请教!!!
- Oracl10g 安装问题,出现:在oraparam.ini中未找到先决条件检查,不执行系统先决条件检查。
- 急.......数据库之间的转换!!!!!!!!!!!
- 创建存储过程!
- 如何建数据库链?
- 关于oracle绑定变量的问题
- 刚刚安装了oracle 11g r1,接下来该做什么?
- Oracle 11G alert_orcl.log中的有以下报警信息 有啥影响? 如何解决?
- oracle 更新varchar2字段为"" 出现乱码
FROM fw_kfgdxx a,fw_tsywfjxx b,dw_tq c,dw_yxbyq d
WHERE a.kfgzdbs=b.kfgzdbs
AND a.kfgzdbh='123456789000000'
and c.tqbs=b.tqbs
and d.tqbs=b.tqbs
update dw_tq
set tqmc = '你要在第一处添加的内容'
where exists (select 1
from (select *
from FROM fw_kfgdxx a, fw_tsywfjxx b
WHERE a.kfgzdbs = b.kfgzdbs
AND a.kfgzdbh = '123456789000000') c
WHERE c.tqbs = t.tqbs);
update dw_yxbyq
set mc = '你要在第二处添加的内容'
where exists (select 1
from (select *
from FROM fw_kfgdxx a, fw_tsywfjxx b
WHERE a.kfgzdbs = b.kfgzdbs
AND a.kfgzdbh = '123456789000000') c
WHERE c.tqbs = t.tqbs);
--写个过程判断一下,在选择插入或更新;
CREATE OR REPLACE procedure add_or_update(str1 VARCHAR2,str2 VARCHAR2,kfgzdbh VARCHAR2,as_log OUT VARCHAR2)
IS
vv_str1 VARCHAR2(20);
vv_str2 VARCHAR2(20);
BEGIN
--得到值
SELECT (SELECT t.tqmc FROM dw_tq t WHERE t.tqbs=b.tqbs),(SELECT y.mc FROM dw_yxbyq y WHERE y.tqbs=b.tqbs)
INTO vv_str1,vv_str2
FROM fw_kfgdxx a,fw_tsywfjxx b
WHERE a.kfgzdbs=b.kfgzdbs
AND a.kfgzdbh=kfgzdbh; --fw_kfgdxx:传入123456789000000
--判断
IF vv_str1 IS NULL OR trim(vv_str1)='' THEN
INSERT INTO ;--插入对应的值
ELSE
UPDATE ; --更新对应的值
END IF;
end p_check_end;