MySQL Project Porting Oracle Issues

Recent company projects to support the Oralce database, we migrated the project, the project using MyBatis need to manually modify the MyBatis SQL XML file, the modification process encountered a lot of problems, recorded here for easy follow-up review.

Data type error ORA-00932

  select            distinct sg.id,                   sg . code,                   sg.NAME,                   sg.ORGANIZATION_ID,                   SG. description,                  -- to_char (sg. DESCRIPTION),                   SG. sort,                   SG. create_user,                    from sys_group  sg

Cause: The Description field type is NCLOB, and distinct does not support operations on the nclob Type field, which can be converted using the To_char function

MySQL Project Porting Oracle Issues