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

From: Arpita Patel <gagarp_at_gmail.com>
Date: Mon, 14 Jan 2019 15:45:22 -0800 (PST)
Message-ID: <c6641391-f177-4825-8e27-39e0a55ffe7f_at_googlegroups.com>


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

Original text of this message