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

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

Answer Question  Select Best Answer