Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t(num integer, word varchar2(100));
insert all
when 1 = 1 then
  into t values (num, word)
when num > 0 then
  into t values (-num, 'minus ' || word)
select 0 as num, 'zero' as word from dual union all 
select 1, 'one'   from dual union all
select 2, 'two'   from dual union all 
select 3, 'three' from dual ;
7 rows affected

select * from t;


NUM
WORD


0
zero

1
one

2
two

3
three

-1
minus one

-2
minus two

-3
minus three