Re: Sql*Loader
From: Arnold Angel <angel_a_at_dep.state.fl.us>
Date: 1997/06/17
Message-ID: <01bc7b18$8ba96fa0$39b849c7_at_ANGEL_A.DEP.STATE.FL.US>#1/1
Date: 1997/06/17
Message-ID: <01bc7b18$8ba96fa0$39b849c7_at_ANGEL_A.DEP.STATE.FL.US>#1/1
Make them both character fields then convert in trigger when you create your view. Use CONCAT() and TO_NUMBER(). CREATE VIEW Name1 AS SELECT ....,TO_NUMBER(CONCAT(SIGN, REVENUE)), ........ FROM table_source Received on Tue Jun 17 1997 - 00:00:00 CEST