Skip to content

Oracle - Alternative Quoting Mechanism (''Q'') for String Literals - parsing error #1718

Closed
@PowalaX

Description

@PowalaX

Parsing Oracle statement:
COMMENT ON COLUMN EMP.NAME IS q'{Name}';

CCJSqlParserUtil.parseStatements error:
net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "Q" <S_IDENTIFIER>
at line 1, column 31.

But, it's OK:
select q'{Its good!}' from dual;

Another parsing error:
select q'{It's good!}' from dual;

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions