Oracle造数据

DROP TABLE GF1.TESTDBA CASCADE CONSTRAINTS; 51Testing软件测试网qD%v/e&_,Q"H7R

51Testing软件测试网Z0~I_P6[ \4D{

  51Testing软件测试网-KdxP/I]|

/v I8@KY"[HX0CREATE TABLE GF1.TESTDBA

*c-Sj[C051Testing软件测试网8J` n;H6\t#\:T o

(

4IA:_2o#h1r(ki0

Z6bgIPf$z0  ACHAR       CHAR(10), 51Testing软件测试网A6O?o3Vr

@,b'X#J.wp:F
m#w0  AVARCHAR2   VARCHAR2(10),

'r |o-d2jXMz0

&A'~cwf:@ }0  ANCHAR      NCHAR(10), 51Testing软件测试网"t(\u.u Pl9C

51Testing软件测试网]DZ6C5z D|"h

  ANVARCHAR2  NVARCHAR2(10), 51Testing软件测试网+bL&Hz0qHb

^#?_,G],~0  ANUMBER     NUMBER(10),

8P Bz4gW,S nf f0

!swfMe^4s7a2]0  ADATE       DATE,

y3[({uP1} |y051Testing软件测试网%Ws&C)wD
]

  ALONG       LONG,

(K&WY(DHd5U!p051Testing软件测试网 ?B uu?8[a

  ARAW        RAW(10),

&E3g+Z6X _8GEO5e0

t"O^@0Q }0  AROWID      ROWID,

n^Y`}K E \r
J051Testing软件测试网hV*HXC T/l

  ABLOB       BLOB,

2u0NTR7wD
X+K:?;ic0

H,\D1?W/r3S$`J0  ACLOB       CLOB, 51Testing软件测试网4uZ-?%_6k7[

1A8Z@ et\0Ec0  ANCLOB      NCLOB,

4Dh MZK i0

7]1E9i(W ae6s!G)k9n0  ABFILE      BFILE, 51Testing软件测试网H6hlG|+z2zl

51Testing软件测试网VR9bD2H!jN B

  AUROWID     UROWID, 51Testing软件测试网2B9~
B&p;z];k

51Testing软件测试网}^I-{Uy|6Q

  AFLOAT      FLOAT(10),

%D4x/Y$@:K@0

o~J&D4PiIF%H?0  AXMLTYPE    SYS.XMLTYPE

(PR5JrN;w(J7H0H0

5d _f%p
G)aMB0

aG|7g,{D0)51Testing软件测试网W%x@IzP;m!W

'K|,Q.]-Pl.FVN,c$O0 51Testing软件测试网*QC M5@hyR

51Testing软件测试网Cx!tB%S(G

插入一条记录

u-R4xUM FE*`-U0INSERT INTO "GF1"."TESTDBA1" ("ACHAR" ,"AVARCHAR2" ,"ANCHAR" , 51Testing软件测试网c%j7CR1K|v

K!W9l7T:mj3@/JZ0    "ANVARCHAR2" ,"ANUMBER" ,"ADATE" ,"ALONG" ,"ARAW" ,"AROWID" , 51Testing软件测试网CTv
n R

51Testing软件测试网,R&DdS[P8e

    "AUROWID" ,"AFLOAT" ) 51Testing软件测试网 z
u&J_jKS1c8x4P0v

51Testing软件测试网`;b[U%Y7n8Q$Ga

    VALUES ('char' ,'varchar2' ,'nchar' ,'nvarchar2' ,10000 ,TO_DATE('2007-01-01','YYYY-MM-DD'),1000,

rk#Vj#Q3T051Testing软件测试网~l0`8F:T_5G"L:Y

    HEXTORAW('fffff'), 51Testing软件测试网le3kR7w I4w[

51Testing软件测试网1D n sR/ew

    CHARTOROWID('AAAA0SAACAAAALiAAA') , 51Testing软件测试网Al)[g'|.\I8~

51Testing软件测试网6m,B6cKa;j

    CHARTOROWID(DBMS_RANDOM.STRING('A',18)) , 100.0  ) 51Testing软件测试网$C"E
L8r.aB4o5M#W&{9c ~

{ t~!uS0  51Testing软件测试网N;O4]I OP'R

51Testing软件测试网2[Jt d k;Ie

插入10000条数据

6z#~M+vJ+_ Zcb}051Testing软件测试网QH1J1T]|^'^

declare

5Q5g%X4|!Q j t051Testing软件测试网s"y6c8}|

        maxrecords constant int:=10000; 51Testing软件测试网/L9P`B:}dO

51Testing软件测试网
Oz+]-K~*mKb

        i int :=0;

a/O_O#M{ ['}0

7z7xa[%t/b(BA$E0    begin

u0k%D%f9`i2W4v+W([/R0

~,t3gNw0        for i in 1..maxrecords loop

{$i,V_*ul.N#lg051Testing软件测试网)V{k9V+\!~I

          INSERT INTO "GF1"."TESTDBA1" ("ACHAR" ,"AVARCHAR2" ,"ANCHAR" ,

z,pH`ktx0

W%i2]Z:G;KX'_~I0           "ANVARCHAR2" ,"ANUMBER" ,"ADATE" ,"ALONG" ,"ARAW" ,"AROWID" , 51Testing软件测试网6t1m9f4Cl1]ide

0a!c6YTR'Y3F z-n0           "AUROWID" ,"AFLOAT" )

bR,n
M ]*s051Testing软件测试网3mAU H l |

          VALUES ('char' ,'varchar2' ,'nchar' ,'nvarchar2' ,10000 ,TO_DATE('2007-01-01','YYYY-MM-DD'),1000,

P2R5Bek051Testing软件测试网9X q J,jE/Qq:M

                                HEXTORAW('fffff'),     CHARTOROWID('AAAA0SAACAAAALiAAA') ,    CHARTOROWID(DBMS_RANDOM.STRING('A',18)) , 100.0  ); 51Testing软件测试网G.p!p(\q7G4b HV N9w

g"X_8Z!\1i.Q\0            commit;          51Testing软件测试网X x` f q'i

{1B8u3bm#]:t0        end loop;

{vBsY ~OCr0

2E1B:YBG-F1\S_0    dbms_output.put_line(' 成功录入数据！ ');

G @!Df:s3t2y0

-?NhJ CI0    commit; 51Testing软件测试网&w7t,U
J_ i"M[

5Xg!v+t/|;X9?gC$h0    end; 51Testing软件测试网 \\$jeA+M+kB

51Testing软件测试网grWdb$u