create table t_single_char(id int , data_desc CHAR(20) , PRIMARY KEY (id) )
/
create table t_single_varchar(id int , data_desc VARCHAR(100) , PRIMARY KEY (id) )
/
create table t_single_varchar2(id int , data_desc VARCHAR2(100) , PRIMARY KEY (id) )
/
create table t_single_nchar(id int , data_desc NCHAR(20) , PRIMARY KEY (id) )
/
create table t_single_nvarchar2(id int , data_desc NVARCHAR2(100) , PRIMARY KEY (id) )
/
create table t_single_number(id int , data_desc NUMBER(5) , PRIMARY KEY (id) )
/
--please ignore the follwing twe table , the data type is don't supported in oracle9i
--create table t_single_binary_double(id int , data_desc BINARY_DOUBLE , PRIMARY KEY (id) )
--create table t_single_binary_float(id int , data_desc BINARY_INTEGER , PRIMARY KEY (id) )
create table t_single_date(id int , data_desc DATE , PRIMARY KEY (id) )
/
create table t_single_timestamp( id int , data_desc TIMESTAMP(3) , PRIMARY KEY (id) )
/
create table t_single_timestamp_zone( id int , data_desc TIMESTAMP(3) WITH TIME ZONE , PRIMARY KEY (id) )
/
create table t_single_timestamp_local_zone( id int , data_desc TIMESTAMP(3) WITH LOCAL TIME ZONE, PRIMARY KEY (id) )
/
create table t_single_raw(id int , data_desc RAW(10) , PRIMARY KEY (id) )
/
create table t_single_long_raw(id int , data_desc LONG RAW, PRIMARY KEY (id) )
/
create table t_single_clob(id int , data_desc CLOB, PRIMARY KEY (id) )
/
create table t_single_nclob(id int , data_desc NCLOB, PRIMARY KEY (id) )
/
create table t_single_ROWID(id int , data_desc ROWID ,PRIMARY KEY (id) )
/
create table t_single_nologging (id int , data_desc varchar2(100) ,primary key (id)) nologging
/
---Insert table
select seq_id.nextval into j from dual;
select seq_id.currval into i from dual;
--insert into one record to each table
insert into T_SINGLE_CHAR values(j,'test');
insert into T_SINGLE_NCHAR values(i,'test');
insert into T_SINGLE_NVARCHAR2 values(i,'test');
insert into T_SINGLE_VARCHAR values(i,'test');
insert into T_SINGLE_VARCHAR2 values(i,'test');
insert into T_SINGLE_NUMBER values(i,10000.00);
insert into T_SINGLE_DATE values(i,sysdate);
insert into T_SINGLE_LONG_RAW values(i, hextoraw('ff'));
insert into T_SINGLE_RAW values(i, hextoraw('dd'));
insert into T_SINGLE_ROWID
select i, DBMS_ROWID.ROWID_CREATE(1,24532,5,65,ROWNUM) from dual;
insert into T_SINGLE_TIMESTAMP values(i,SYSTIMESTAMP );
insert into T_SINGLE_TIMESTAMP_LOCAL_ZONE values(i ,SYSTIMESTAMP );
insert into T_SINGLE_TIMESTAMP_ZONE values(i,SYSTIMESTAMP);
insert into T_SINGLE_CLOB values(i,empty_clob());
insert into T_SINGLE_NCLOB values(i,empty_clob());
