Re: SQL*Loader-350: Expecting = or "<>", found "(".

Found this useful:
https://stackoverflow.com/questions/46095847/sqlloader-how-to-use-substr-in-when-clause-correctly

Solution:
Use position in when condition as:

append
into table <TABLE_NAME>
when
TRANSACTION_TYPE = 'XXX'
and USE != '0'
and (13:14) = '00'

Thanks Received on Tue Jan 15 2019 - 00:45:22 CET