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>
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