DROP TABLE GF1.TESTDBA CASCADE CONSTRAINTS;
CREATE TABLE GF1.TESTDBA
(
ACHAR CHAR(10),
AVARCHAR2 VARCHAR2(10),
ANCHAR NCHAR(10),
ANVARCHAR2 NVARCHAR2(10),
ANUMBER NUMBER(10),
ADATE DATE,
ALONG LONG,
ARAW RAW(10),
AROWID ROWID,
ABLOB BLOB,
ACLOB CLOB,
ANCLOB NCLOB,
ABFILE BFILE,
AUROWID UROWID,
AFLOAT FLOAT(10),
AXMLTYPE SYS.XMLTYPE
)
插入一条记录
INSERT INTO "GF1"."TESTDBA1" ("ACHAR" ,"AVARCHAR2" ,"ANCHAR" ,
"ANVARCHAR2" ,"ANUMBER" ,"ADATE" ,"ALONG" ,"ARAW" ,"AROWID" ,
"AUROWID" ,"AFLOAT" )
VALUES ('char' ,'varchar2' ,'nchar' ,'nvarchar2' ,10000 ,TO_DATE('2007-01-01','YYYY-MM-DD'),1000,
HEXTORAW('fffff'),
CHARTOROWID('AAAA0SAACAAAALiAAA') ,
CHARTOROWID(DBMS_RANDOM.STRING('A',18)) , 100.0 )
插入10000条数据
declare
maxrecords constant int:=10000;
i int :=0;
begin
for i in 1..maxrecords loop
INSERT INTO "GF1"."TESTDBA1" ("ACHAR" ,"AVARCHAR2" ,"ANCHAR" ,
"ANVARCHAR2" ,"ANUMBER" ,"ADATE" ,"ALONG" ,"ARAW" ,"AROWID" ,
"AUROWID" ,"AFLOAT" )
VALUES ('char' ,'varchar2' ,'nchar' ,'nvarchar2' ,10000 ,TO_DATE('2007-01-01','YYYY-MM-DD'),1000,
HEXTORAW('fffff'), CHARTOROWID('AAAA0SAACAAAALiAAA') , CHARTOROWID(DBMS_RANDOM.STRING('A',18)) , 100.0 );
commit;
end loop;
dbms_output.put_line(' 成功录入数据! ');
commit;
end;