insert into t_zfk_towcolor_single01 values('10003',01,07,09,16,23,29,03);
insert into t_zfk_towcolor_single01 values('10003',01,06,08,15,29,30,05);
insert into t_zfk_towcolor_single01 values('10003',06,12,13,17,21,29,06);
insert into t_zfk_towcolor_single01 values('10003',04,07,08,14,23,29,14);
insert into t_zfk_towcolor_single01 values('10003',06,11,16,25,29,33,03);
insert into t_zfk_towcolor_single01 values('10003',06,09,22,23,25,29,05);
insert into t_zfk_towcolor_single01 values('10003',04,08,19,21,26,29,06);
insert into t_zfk_towcolor_single01 values('10003',06,14,16,20,29,30,14);
insert into t_zfk_towcolor_single01 values('10003',06,09,16,21,29,31,03);
insert into t_zfk_towcolor_single01 values('10003',06,13,21,29,31,33,05);
。
好像这样的直接数字 如何把它装在到集合类型中
insert into t_zfk_towcolor_single01 values('10003',01,06,08,15,29,30,05);
insert into t_zfk_towcolor_single01 values('10003',06,12,13,17,21,29,06);
insert into t_zfk_towcolor_single01 values('10003',04,07,08,14,23,29,14);
insert into t_zfk_towcolor_single01 values('10003',06,11,16,25,29,33,03);
insert into t_zfk_towcolor_single01 values('10003',06,09,22,23,25,29,05);
insert into t_zfk_towcolor_single01 values('10003',04,08,19,21,26,29,06);
insert into t_zfk_towcolor_single01 values('10003',06,14,16,20,29,30,14);
insert into t_zfk_towcolor_single01 values('10003',06,09,16,21,29,31,03);
insert into t_zfk_towcolor_single01 values('10003',06,13,21,29,31,33,05);
。
好像这样的直接数字 如何把它装在到集合类型中
如果是excel表,txt 等格式的,可以直接导入数据库。------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
type type_recor is record
( expect varchar2(10),
red01 number(2),
red02 number(2),
red03 number(2),
red04 number(2),
red05 number(2),
red06 number(2),
blue01 number(2)
);
type type_indexvar is table of type_recor index by binary_integer;
RecVar_table type_indexvar;
begin
insert into RecVar_table values('10003',01,07,09,16,23,29,03);
dbms_output.put_line(RecVar_table(1).expect);
end;
for i in 1..10000 loop
RecVar_table(i):=('10003',01,07,09,16,23,29,03);
..........
就是不知道有多少条
for i in 1..x loop
deptno not null,
sal,
emp_no not null,
padding,
constraint e_pk primary key(emp_no)
)as
--insert into emp2如果表已存在则插入
with generator as
(
select
rownum id
from all_objects where rownum<=1000
)
select
mod(rownum,6),
rownum,
rownum,
rpad('X',60)
from
generator v1,
generator v2
where rownum<=50000;
2、禁用一切影响速度的显示 如:set echo off 等
3、执行.sql 如@路径\insert.sql
select * from 表名 for update
create table test(
col1 varchar2(20),
col2 varchar2(20),
col3 varchar2(20),
col4 varchar2(20),
col5 varchar2(20),
col6 varchar2(20),
col7 varchar2(20),
col8 varchar2(20)
);2.创建sqlldr控制文件c:\test.ctl
load data
infile *
into table test
append
fields terminated by ',' optionally enclosed by '"'
(
col1,
col2,
col3,
col4,
col5,
col6,
col7,
col8
)
BEGINDATA
10003,01,07,09,16,23,29,03
10003,01,06,08,15,29,30,05
10003,06,12,13,17,21,29,06
10003,04,07,08,14,23,29,14
10003,06,11,16,25,29,33,03
10003,06,09,22,23,25,29,05
10003,04,08,19,21,26,29,06
10003,06,14,16,20,29,30,14
10003,06,09,16,21,29,31,03
10003,06,13,21,29,31,33,053.数据通过sql loader导入表
c:\>sqlldr test/test control=c:\test.ctl
2. disable constraint and indexes.
ALTER TABLE test disable CONSTRAINT TEST_PK cascade drop index.
drop index idx1;
3. insert data.
4. enable constraint and indexes.
ALTER TABLE test enable novalidate CONSTRAINT TEST_PK using index tablespace ts_name.
create index...
5. alter table TEST_INVOICE_HISTORY logging.