摘要: updatetest1asetname=(selectnamefromtest2bwherea.no=b.no and rownum = 1)where exists(select /*+ push_subq*/ 1fromtest2bwherea.no=b.no and rownum = 1); select * from dba_tab_col_statistics where table_name='BUSINESSBASICINFO'select count(0) from BusinessBasicInfo,CorporationMainTable; begin db 阅读全文
posted @ 2011-05-26 08:12 小さいです哥 阅读(213) 评论(0) 推荐(0)