Re: Disabling check constraints

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 18 Oct 2006 08:12:36 -0700
Message-ID: <1161184351.914033@bubbleator.drizzle.com>

Mladen Gogala wrote:
> 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.

My point wasn't that is isn't valid syntax. This is too:

SELECT ALL col1, col2 FROM t;

But no one in Oracle shops writes the "ALL".

If you want to get technical, at least in 10g, what you should write is: "COMMIT WORK WRITE IMMEDIATE WAIT" ... I don't see much of that either.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Oct 18 2006 - 10:12:36 CDT