tmp_t1.sql

create table tmp_t1
(
  amount number,
  txt varchar2(50 char)
);

insert into tmp_t1
   (amount, txt)
 values
   (1, 'text 1');
insert into tmp_t1
   (amount, txt)
 values
   (2, 'text 2');
insert into tmp_t1
   (amount)
 values
   (3);
insert into tmp_t1
   (amount, txt)
 values
   (3, 'text 3');
insert into tmp_t1
   (amount, txt)
 values
   (-1, 'text 4');
insert into tmp_t1
   (amount, txt)
 values
   (-2, 'text 5');
insert into tmp_t1
   (amount)
 values
   (-2);
insert into tmp_t1
   (amount, txt)
 values
   (-3, 'text 6');
commit;