你的总表的列应该和3个职能表相同吧,你问在总表里面怎么调取,应该写个sql就行create table total_table asselect * from(select * from table_zhineng1 where trunc(begin_time,'w') = trunc(sysdate,'w') or trunc(end_time,'w')=trunc(sysdate,'w')union allselect * from table_zhineng2 where trunc(begin_time,'w') = trunc(sysdate,'w') or trunc(end_time,'w')=trunc...
|