可以做一个专题讲座…… 你的数据库是先启动后建立吗?启动数据库: c:\windows>svrmgrl svrmgrl> connect internal/oracle svrmgrl> startup [force]创建表空间: sql> create tablespace test datafile 'd:\oradata\test.ora' size 10M;创建用户: sql> create user kane identified by kane default tablespace test temporary tablespace test; 授权: sql> grant dba to kane; sql> grant select any table to kane; 创建表: sql> conn kane/kane sql> create table test_kane( num number, ch char(2) ); 插入数据: sql> insert into test_kane(num,ch) values('1','a'); sql> commit; sql> delete from test_kane; sql> commit; SQL> declare 2 n int; 3 c char(2); 4 begin 5 for i in 1..255 loop 6 n := i; 7 c := chr(n); 8 insert into test_kane(num,ch) values(n,c); 9 end loop; 10 end; 11 / sql> commit; sql> select * from test_kane;
你的数据库是先启动后建立吗?启动数据库:
c:\windows>svrmgrl
svrmgrl> connect internal/oracle
svrmgrl> startup [force]创建表空间:
sql> create tablespace test datafile 'd:\oradata\test.ora' size 10M;创建用户:
sql> create user kane identified by kane
default tablespace test temporary tablespace test;
授权:
sql> grant dba to kane;
sql> grant select any table to kane;
创建表:
sql> conn kane/kane
sql> create table test_kane(
num number,
ch char(2)
);
插入数据:
sql> insert into test_kane(num,ch) values('1','a');
sql> commit;
sql> delete from test_kane;
sql> commit;
SQL> declare
2 n int;
3 c char(2);
4 begin
5 for i in 1..255 loop
6 n := i;
7 c := chr(n);
8 insert into test_kane(num,ch) values(n,c);
9 end loop;
10 end;
11 /
sql> commit;
sql> select * from test_kane;