demo03.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 13 行

create table t
( a int,
  b varchar2(4000) default rpad('*',4000,'*'),
  c varchar2(3000) default rpad('*',3000,'*')
)
/
insert into t (a) values ( 1);
insert into t (a) values ( 2);
insert into t (a) values ( 3);
delete from t where a = 2 ;
insert into t (a) values ( 4);
select a from t;