database : oracle
sql : INSERT INTO account t (name, addr, phone) SELECT * FROM user
error :
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "t "" at line 1, column 21.
Was expecting one of:
"SET" ...
"WITH" ...
"SELECT" ...
"(" ...
"(" ...
"(" ...
"(" ...
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16970)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16823)
at net.sf.jsqlparser.parser.CCJSqlParser.Insert(CCJSqlParser.java:1043)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:138)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:54)
database : oracle
sql : INSERT INTO account t (name, addr, phone) SELECT * FROM user
error :
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "t "" at line 1, column 21.
Was expecting one of:
"SET" ...
"WITH" ...
"SELECT" ...
"(" ...
"(" ...
"(" ...
"(" ...