ÕâÑùµÄoracleÓï¾äÓиü¼òµ¥µÄ·½·¨Âð

SQL code:
create tmp as
select a,b,a*c,0 as a1 from tableA where a>10;

update tmp q
set q.a1 = (select sum(w.a1) from tableB w where w.b = q.b);

select * from tmp;

drop table tmp;


Õâ¸öÊÇÎÒ¼ò»¯Á˵ÄSQLÓï¾ä£¬ÇëÎÊÓиü¼ò±ãµÄ·½·¨Âð£¿
ÏëÓÃÊÓͼµÄ£¬µ«²»ÖªµÀÔõôдSQLÓï¾äºÃ£¡

ÒòΪ²»Ïëÿ´Î¶¼create±í£¡ÍòÒ»¶àÈËÓõÄʱºò¾Í³ö´íÁË£¡

---

ÁÙʱ±í£¿
ʹÓÃORACLEÈ«¾ÖÁÙʱ±í£¬Ò»´Î´´½¨£¬ÓÀ¾ÃʹÓá£

---

²Î¿¼ http://www.ccctttv.cn/Promote.aspx?UID=ht8326

---

ÄãÊÇ´ÓÁ½¸ö±í»ñÈ¡Êý¾Ý,¾ÛºÏ²»°üÀ¨ËùÓеÄ×Ö¶Î.¹À¼ÆÖ»ÄÜÕâôдÁË.

---

2Â¥µÄÐÖµÜ˵ÏêϸµãÐÐÂð£¬Ð»Ð»À²

---

create or repleace view a as
select q.a,q.b,q.a*q.c as ac,0 as a1 from tableA q,tableB w where w.b=q.b and q.a>10

ÒýÓÃ

SQL codecreate tmpasselect a,b,a*c,0as a1from tableAwhere a>10;update tmp qset q.a1= (selectsum(w.a1)from tableB wwhere w.b= q.b);select*from tmp;droptable tmp;

Õâ¸öÊÇÎÒ¼ò»¯Á˵ÄSQLÓï¾ä£¬ÇëÎÊÓиü¼ò±ãµÄ·½·¨Âð£¿
ÏëÓÃÊÓͼµÄ£¬µ«²»ÖªµÀÔõôдSQLÓï¾äºÃ£¡

ÒòΪ²»Ïëÿ´Î¶¼create±í£¡ÍòÒ»¶àÈËÓõÄʱºò¾Í³ö´íÁË£¡

---

create or repleace view a as
select q.a,q.b,q.a*q.c as ac,0 as a1 from tableA q,tableB w where w.b=q.b and q.a>10

ÒýÓÃ

SQL codecreate tmpasselect a,b,a*c,0as a1from tab