Re: Disabling check constraints

On Tue, 17 Oct 2006 08:09:21 -0700, DA Morgan wrote:

> No one, in Oracle, writes
> COMMIT WORK.
No reasons not to do that:

SQL> create table emp1 as select * from emp where rownum<0;

Table created.

SQL> insert into emp1
  2 select * from emp;

14 rows created.

SQL> commit work;

Commit complete.

As you see, "commit work" works perfectly.

-- 
http://www.mladen-gogala.com