如果可以通用,则这样写:
select
(a.col1) as col1,
(a.col2) as col2
from table_name a
不通用的就做二个dw,以_ora,_sql来区别
如 dw_mmkt_ora,语法如下
(a.col1) as col1,
(a.col2) as col2
from table_name a
where nvl(a.col1,0)<>0
如 dw_mmkt_sql,语法如下
(a.col1) as col1,
(a.col2) as col2
from table_name a
where isnull(a.col1,0)<>0