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

From: Arpita Patel <gagarp_at_gmail.com>
Date: Mon, 14 Jan 2019 13:34:45 -0800 (PST)
Message-ID: <a8210e67-8f72-48a0-99bc-b824238a676b_at_googlegroups.com>

In control File I need to include one more when condition that checks if last two digit of NUMBER is in range 00 to 19 like: "substr(NUMBER,-2,2) in (00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,16,17,18,19)"

control file looks like:
append
into table <TABLE_NAME>
when
TRANSACTION_TYPE = 'XXX'
and USE != '0' and
substr(NUMBER,-2,2) in (00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,16,17,18,19)

getting error:
SQL*Loader-350: Syntax error at line 9.
Expecting = or "<>", found "(".
substr(NUMBER,-2,2) in (00,01,02,03,04,05,06,07,08,09,10,11 ^

please suggest how to use the multiple options in when condition. Thanks Received on Mon Jan 14 2019 - 22:34:45 CET