sql - how to convert and compare some data from different tables -

sql - how to convert and compare some data from different tables -

i compare info different databases. think utilize minus operator comparison. however, have hard conversion. instance how convert number - 91108234116 raw() toward varchar2(). please tell me how convert info below. utilize pl/sql developer.

thanks cooperation in advance.

for conversion can seek this:

select cast(raw_column varchar2(11)) table1;

then can compare equality operator '='.

here's conversion matrix other info types.

sql oracle plsql