有一张名叫GOODS的表,需要在这张表里插入1000表随机数据,请问该怎么插?
表结构如下
ID INTEGER not null,
GOODS_ID INTEGER not null,
PRIVILEGE_ID INTEGER,
DEVELOPER_USER_ID INTEGER,
TITLE VARCHAR2(100),
CONTENT VARCHAR2(4000),
CONFIRM_STATUS INTEGER,
GOODS_NUMBER NUMBER(2,1),
表结构如下
ID INTEGER not null,
GOODS_ID INTEGER not null,
PRIVILEGE_ID INTEGER,
DEVELOPER_USER_ID INTEGER,
TITLE VARCHAR2(100),
CONTENT VARCHAR2(4000),
CONFIRM_STATUS INTEGER,
GOODS_NUMBER NUMBER(2,1),
SYS_GUID()