OraFAQ Forum: Forms » Problem with SELECT UNION.

Home » Developer & Programmer » Forms » Problem with SELECT UNION.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with SELECT UNION. [message #78104]

Fri, 18 January 2002 00:42

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.

Report message to a moderator

Re: Problem with SELECT UNION. [message #78109 is a reply to message #78104]

Fri, 18 January 2002 04:30

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;

Report message to a moderator

Previous Topic:	Re: free material for oracle 8i
Next Topic:	Disable first field in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 13:39:14 CST 2025