insert into select和select into 的区别,sys_guid()乱码问题

INSERT INTO SELECT:目标表要存在

INSERT INTO PLAT_ORG ("ID", "OFFICE_ID", "ORG_CODE", "ORG_NAME", "ORG_LEVEL", "ISEND", "PARENT_ID", "AREA_ID")
SELECT ID,OFFICE,CODE,NAME,LAYERS,ISEND,PID,AREAID FROM SHEET

SELECT INTO:目标表要不存在

SELECT sys_guid(),OFFICE,CODE,NAME,LAYERS,ISEND,'',AREAID INTO SHEET1 FROM SHEET

sys_guid()乱码

SELECT rawtohex(sys_guid()),OFFICE,CODE,NAME,LAYERS,ISEND,'',AREAID  FROM SHEET

原文地址:https://www.cnblogs.com/zuoyoufengyuan/p/9229672.html