Home » Developer & Programmer » Forms » Problem with SELECT UNION.
Problem with SELECT UNION. [message #78104] Fri, 18 January 2002 00:42 Go to next message
Passes
Messages: 1
Registered: January 2002
Junior Member
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(3
i need return a number(2) ?

Thanks.
Re: Problem with SELECT UNION. [message #78109 is a reply to message #78104] Fri, 18 January 2002 04:30 Go to previous message
Shilpa
Messages: 59
Registered: November 2001
Member
I don't know what you are trying to do but

for eg:
emp table has deptno number(2);
dept table has deptno number(2);

when I create a view like the following and describe it the deptno field of the view is number(2).

create view temp
as (select deptno
from emp
union
select deptno
from dept);

desc temp;
Previous Topic: Re: free material for oracle 8i
Next Topic: Disable first field in form
Goto Forum:
  


Current Time: Fri Mar 29 05:11:11 CDT 2024