Join two Columns with different datatype

How to join two columns which is having different datatype? Say Coulmn1 with Varchar2 datatype and Coulmn2 with long datatype.

Questions by RPush   answers by RPush

Showing Answers 1 - 3 of 3 Answers

PK

  • Feb 28th, 2012
 

You can join the columns with two different data types by using to_char, to_number to_date functions.
For e.g. one field is a varchar which stores number and other field is a number then you can use.
to_number(var_column) = number_column

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions