• Case sensitivity? (collaction/Oracle case sensitivity)

    Mix of datatypes? trim(x)=:comp -> characters? :comp=0 -> number?

    Why is the trim added in the last line?

    You have supplier_country = receiver_country and :ccty = 0 (without trim)

    and then suddenly trim(supplier_country) = :ccty and trim(receiver_country) = :ccty

    -> supplier_country = receiver_country and supplier_country=trim(:ccty) ?