create view viewname as
select ..,greateste(a.date1,b.date1,c.date1) date1,....
from tab1 a,
tab2 b,
tab3 c
where ....
select ..,greateste(a.date1,b.date1,c.date1) date1,....
from tab1 a,
tab2 b,
tab3 c
where ....
不过函数拼写错了
greatest()SQL> select greatest(1,2,3,4,5) from dual;GREATEST(1,2,3,4,5)
-------------------
5SQL>