create view problem

From: <www_dba_at_my-deja.com>
Date: Mon, 13 Mar 2000 07:15:18 GMT
Message-ID: <8ai4i5$989$1@nnrp1.deja.com>

  1 create view tempvw1 as select audit_date date2 from table1   2 union
  3* select null date1 from table2;

create view tempvw1 as select audit_date date2 from person

                              *

ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression

How can I overcome this problem?
TIA. Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 13 2000 - 01:15:18 CST