SQL Server How to use the OR condition in when clause of SQL Loader control file

i7uaboj4 于 2023-03-07 发布在其他

关注(0)|答案(2)|浏览(139)

I am trying to use the OR condition in when clause in control file, This this my code in control file :

load data
INFILE 'router.txt'
INTO TABLE ROUTER_ATTLAS_TABLENAME  
APPEND
**WHEN ((1) = 'J' or  (1) = 'D2'  or  (1) = 'vJ' or  (1) = 'VJ' )**
FIELDS TERMINATED BY '\|'

I am getting a error :SQL*Loader-350: Syntax error at line 5.

Expecting ")", found "or".
WHEN ((1) = 'J' or  (1) = 'D2'  or  (1) = 'vJ' or  (1) = 'VJ' )

Please suggest me an correct syntax.

sql-server

来源：https://stackoverflow.com/questions/39993083/how-to-use-the-or-condition-in-when-clause-of-sql-loader-control-file

2条答案

按热度按时间

z9smfwbn1#

You just need two "insert" command in the same table. Copy...

INTO TABLE ROUTER_ATTLAS_TABLENAME
APPEND WHEN ((1) = 'J' or (1) = 'D2' or (1) = 'vJ' or (1) = 'VJ' ) FIELDS TERMINATED BY '|'

using different WHEN to each desired one.

赞(0）回复(0）举报 2023-03-07

hfyxw5xn2#

I'm afraid OR is not allowed in a WHEN clause: https://docs.oracle.com/cd/B28359_01/server.111/b28319/ldr_control_file.htm#i1005657

赞(0）回复(0）举报 2023-03-07

我来回答

SQL Server How to use the OR condition in when clause of SQL Loader control file

2条答案

相关问题

热门标签

最新问答