摘要: 如何将查询出的空值插入到Oracle不可为空的字段中?? 阅读全文
posted @ 2019-07-11 17:31 TinyBlackWhelpling 阅读(142) 评论(0) 推荐(0) 编辑
摘要: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 违反唯一约束条件 (SYSTEM.PK_B2B_COMMODITY_KC)ORA-02063: 紧接着 line (起自 DSJK) 阅读全文
posted @ 2019-07-10 16:23 TinyBlackWhelpling 阅读(163) 评论(0) 推荐(0) 编辑
摘要: insert into table1(label1,label2,label3,lable4)select * from(select a.t1 as label1,a.t2 as label2,b.t3 as label3,b.t4 as label4from table2 ajoin table 阅读全文
posted @ 2019-07-09 16:48 TinyBlackWhelpling 阅读(3224) 评论(2) 推荐(1) 编辑