Problem with SELECT UNION

[jom]

Hi , I need a solution for this problem

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

Thanks.

[aarroyob]

If the columns are the same in both tables try with:

select A from table A
union all
select B from table B

Columns must the named equal too.

Hope that helps

Angel

[jom]

Not is a valid solution,
oracle returns a
number(38)
but no a number(2)

[julian]

> Oracle returns a Number(38)

How did you come to that conclusion?

[jom]

Oracle return the greastest size of number
in select union.

[aarroyob]

But in your first post you said in both tables this column is number(2). Then could us explain how oracle returns number(38)?

[jom]

Select A from table1
Union
Select B from table2
Where A and B are number(2)

if the query is
Select A from table1
Oracle returns the type of column --> number(2)

but in the Select Union :

Select A from table1
Union
Select B from table2

is equal to

Select number from table1
Union
Select number from table2

and the results is a number with the most size
number(38) and no the type of the column
number(2).

[julian]

I am sorry, I am lost here... I don't understand how you figure out that the returned size is 38.

[aarroyob]

I don´t understand neither sorry

[Mnemonical]

Are you sure it's oracle you're using? Isn't it Ms Access?

F.