insert.sql

derby database source code.good for you.

create table i2 (i int, t int, s smallint, l bigint, r real, dp double, dc dec);
create table tab1 (
				i integer, 
				t integer, 
				s integer, 
				l bigint,
				r real, 
				dp double,
				dc decimal);

insert into i1 values (1, 2, 3, 4, 5.5, 6.6, 7.7);
insert into i1 values (null, null, null, null, null, null, null);

insert into tab1 values(1, 
				cast(2 as int), 
				cast(3 as smallint), 
				cast(4 as bigint), 
				cast(5.5 as real), 
				cast(6.6 as double), 
				7.7);
insert into tab1 values (null, null, null, null, null, null, null);

insert into i2 select i, i, i, i, i, i, i from i1;
insert into i2 select t, t, t, t, t, t, t from i1;
insert into i2 select s, s, s, s, s, s, s from i1;
insert into i2 select l, l, l, l, l, l, l from i1;
insert into i2 select r, r, r, r, r, r, r from i1;
insert into i2 select dp, dp, dp, dp, dp, dp, dp from i1;
insert into i2 select dc, dc, dc, dc, dc, dc, dc from i1;
select * from i2;
delete from i2;

insert into i2 select i, t, s, l, r, dp, dc from tab1;
select * from i2;

-- get the rest
create table i3 (b char(1) for bit data, 
			bv varchar(1) for bit data, 
			lbv long varchar for bit data,
			c char(10),
			cv varchar(10),
			lvc long varchar,
			dt date,
			t time,
			ts timestamp);

create table i4 (b char (1) for bit data, 
			bv varchar(1) for bit data, 
			lbv long varchar for bit data,
			c char(10),
			cv varchar(10),
			lvc long varchar,
			dt date,
			t time,
			ts timestamp);

insert into i3 values (X'11', X'22', X'25', '3', '4', '5', '1990-10-10', 
			'11:11:11', '1990-11-11 11:11:11');
insert into i3 values (null, null, null, null, null, null, null, null, null);

insert into i4 select * from i3;
select * from i4;
delete from i4;

create table tab2 (
	c char,
	cv varchar(10),
	lvc long varchar,
	dt date,	
	t time,	
	ts timestamp);

insert into tab2 values ('3', '4', '5', '1990-10-10', 
			'11:11:11', '1990-11-11 11:11:11');
insert into tab2 values (null, null, null, null, null, null);
insert into i4 (c, cv, lvc, dt, t, ts) select c, cv, lvc, dt, t, ts from tab2;