摘要：
update AllPunishment a set (a.CreditID)=(select b.CreditID from CorporationMainTable b where b.CorporationName=a.CorporationName and b.OrganizationCode=a.OrganizationCode and rownum =1) where exists (select 1 from CorporationMainTable b where b.CreditID=a.CreditID) 阅读全文
posted @ 2011-04-06 12:33
小さいです哥
阅读(256)
评论(0)
推荐(0)
摘要：
create tablespace Manage_Data logging datafile '/oradata/creditma/Manage_Data01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management localSEGMENT SPACE MANAGEMENT AUTO;create temporary tablespace Manage_Temp tempfile '/oradata/creditma/Manage_Temp01.dbf' size 4096m;cr 阅读全文
posted @ 2011-04-06 12:21
小さいです哥
阅读(224)
评论(1)
推荐(1)
