Menu

#12 select statement with '||' in plsql

open
nobody
None
5
2012-12-07
2010-12-02
Anonymous
No

My sql statement is
select 'dd'||'ss' from bxf_rpt_ap

The JsqlParser reports errors:
Caused by: net.sf.jsqlparser.parser.TokenMgrError: Lexical error at line 1, column 12. Encountered: "|" (124), after : ""
at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:1355)

Discussion