Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using union between long and varchar2

Status
Not open for further replies.
ociruj

ociruj

Programmer
Nov 8, 2002
22
PH
i have 3 select statements using union.

lets say

select ord_no1, description1, amount1
from table1
union
select ord_no2, description2, amount2
from table2
union
select ord_no3, description3, amount3
from table3


wherein DESRICRIPTION1 has long datatype
while DESRIPTION2 and DESCRIPTION3 has varchar2 datatype...

how can i use description1 with union?
 
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
156
jandresHDS
J
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
385
Olutee360
Olutee360
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
2K
EM1107
EM1107
kernal
  • Locked
  • Question
Extract after and between spaces in a string 1
Replies
1
Views
250
johnherman
johnherman
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
272
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top