pl/sql資料庫怎么向查出來的表中的列添加資料？求解！急！-有解無憂

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'

uj5u.com熱心網友回復：

SELECT c.tqmc,d.mc
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

uj5u.com熱心網友回復：

大概這樣就可以如下..直接用update陳述句更新..
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);

uj5u.com熱心網友回復：

參考 2 樓 s1024783043的回復:

大概這樣就可以如下..直接用update陳述句更新..
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);

這個好像不行，這個表查詢出來的這列下面是空值，要想它添加。你看我發的圖片，把我圖片寫的FOR UPDATE去掉。你再看看，謝謝啦！

uj5u.com熱心網友回復：

參考 1 樓宋哥的回復:

SELECT c.tqmc,d.mc
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

謝咯，但是這是查詢出來是空值，這兩個是空值，我是要怎么向它添加值，能否幫我解決？

uj5u.com熱心網友回復：



--寫個程序判斷一下，在選擇插入或更新；

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;

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/86443.html

標籤：基礎和管理

上一篇：vs連接Oracle服務器

下一篇：oracle ORA-01033