Problem with Select UNION

From: aaa <passes334_at_terra.es>
Date: 18 Jan 2002 02:31:37 -0800
Message-ID: <1f77a837.0201180231.641ec442_at_posting.google.com>


Hi , I need a solution for this problem

Select A from Table1
Union [all]
Select B from Table2
;
Where A and B are Number(2) , but
Oracle returns a Number(38)
i need return a number(2) ?

Thanks. Received on Fri Jan 18 2002 - 11:31:37 CET

Original text of this message