报某个字段错误

0 INSERT INTO ods.ty_md_businessplate (id, createBy, createTime, modifyBy, modifyTime, deleted, disabled, sort, “name”, remark) VALUES ( 295939592245350400, 0, ‘2020-09-28 11:12:35+08’, 0, NULL, ‘FALSE’, ‘FALSE’, 1, ‘地产开发’, NULL) was aborted: ERROR: syntax error at or near “sort” 位置:105 Call getNextException to see other errors in the batch.

把语法放到DB查询分析器里面,出错字段名称变成蓝色。给字段名称加引号解决。
image.png

oracle数据库连接需要/

image.png