• 欢迎访问SimonHu的博客,推荐使用360浏览器和Chrome浏览器访问本网站

标签:oracle

oracle插入主键与显示id不一致

SELECT xshtest.XSHE_PRODUCT_CFG_SEQ.nextval as id from DUAL这里查出序列为1102606,然后insert到库中insert into xshtest.XSHE_PRODUCT_CFG (id,product_id,cateid) VALUES (1102606,'313132221&#……