当要存数据到oracle数据库中时,要确认某一条数据的某个属性在数据库中是否已经存在,不存在则插去,存在则不插入
INSERT INTO PPORDER (
ASNCREATEKEY,
BOXCODE,
SKUCODE,
FACTORYID,
DELIVERID,
TEAMNO,
ASN,
PRODTIME,
ASNLINE,
STAUTS
) SELECT
'123' AS ASNCREATEKEY,
'123' AS BOXCODE,
'123' AS SKUCODE,
'123' AS FACTORYID,
'123' AS DELIVERID,
'123' AS TEAMNO,
'123' AS ASN,
TO_DATE ('1988-5-18', 'yyyy-mm-dd') AS PRODTIME,
'123' AS ASNLINE,
'0' AS STAUTS
FROM
dual
WHERE
NOT EXISTS (
SELECT
*
FROM
PPORDER
WHERE
ASNCREATEKEY = '123'
);
注意:
要添加的字段后面记得要添加AS + 属性 不然插入数据时,如果数据库中数据存在则不插入,如果不存在则数据库中有多少条数据就插入多少条要插入的数据,如果数据很多删除很麻烦的。