View & Number columns

From: New Age <parbha_at_iquest.net>
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 the

view 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
		Prabha

Received on Wed May 01 1996 - 00:00:00 CEST