ger11script-no-constraints

--skript--
drop table notunique purge;
--
create table notunique(
numb number(1)
);
--
insert into notunique values (1);
insert into notunique values (2);
--
select * from notunique;
commit;
--
INSERT INTO notunique
    SELECT * FROM notunique;
--
select count(*) from notunique;
--
select * from notunique;
--
insert into notunique values (3);
select count(*) from notunique;
--
ROLLBACK;
--
rollback;
--
select count(*) from notunique;
--

--------------------
--output not copy--

Table NOTUNIQUE dropped.


Table NOTUNIQUE created.


1 row inserted.


1 row inserted.


      NUMB
----------
         1
         2


Commit complete.


2 rows inserted.


  COUNT(*)
----------
         4


      NUMB
----------
         1
         2
         1
         2


1 row inserted.


  COUNT(*)
----------
         5


Rollback complete.


Rollback complete.


  COUNT(*)
----------
         2