cannot do outer join with the 'like' operator

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Thu, 27 Sep 2001 20:23:18 +0800
Message-ID: <5e66rtksgk3fbt69mmdofm9eg39ksadbea@4ax.com>

Dear all,

Can anyone show me how to do outer join with the 'like' operator?

SQL> l
  1 select a.fsc, b.category_code
  2 from tb_products a, tb_category b
  3* where a.secco_code like b.secco_prefix || '%' (+) SQL> /
where a.secco_code like b.secco_prefix || '%' (+)

                                              *

ERROR at line 3:
ORA-00933: SQL command not properly ended

Inner join is ok for the 'like' operator, though.

Thanks,
Dino Received on Thu Sep 27 2001 - 07:23:18 CDT