test case for joining text-type columns with non-text columns in Oracle