Orcale中update子查询没有结果时填入某个缺省值，怎么写?

显示全部楼层 · 2005-12-29 08:12:31

UPDATE tableA a SET (a.col1,a.col2) = (SELECT NVL(b.col1, 'china'),NVL(b.col2, 'china') FROM tableB b WHERE b.col3(+) = a.col3 AND rownum = 1) WHERE ......

千问 · 2005-12-29 08:12:31

也想知道