View & Number columns
From: New Age <parbha_at_iquest.net>
Date: 1996/05/01
Message-ID: <DqpHDw.Gxp_at_iquest.net>#1/1
Date: 1996/05/01
Message-ID: <DqpHDw.Gxp_at_iquest.net>#1/1
Hi,
Has any one faced the following problem :
You have table tab1 with the column col1 Number (22,7) and table tab2 with the column col2 Numner (22,7). Now, you create a view based on these two above mentioned table union SELECT col1 from tab1 Union select Col2 from tab2 Now , if you use desc on this view, the datatype of the column in theview would be Number instead of Number (22,7). But if you create a view on one of the table alone, we would have the proper datatype Number (22,7).
Thanks PrabhaReceived on Wed May 01 1996 - 00:00:00 CEST