Re: Difference between DELETE and DELETE FROM statement

From: Ninjali <nickli2000_at_gmail.com>
Date: Mon, 3 Aug 2009 06:34:53 -0700 (PDT)
Message-ID: <83871c11-9809-41ea-999c-1e2bccfc4dd8_at_e18g2000vbe.googlegroups.com>

On Aug 3, 12:22 am, kevin <majun..._at_hotmail.com> wrote:
> On Aug 3, 2:00 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
>
>
>
>
>
> > "Ninjali" <nickli2..._at_gmail.com> a écrit dans le message de news:
> > 7c6e2c4e-ef5e-4e6b-8ac6-0d7e69552..._at_d23g2000vbm.googlegroups.com...
> > | Hi,
> > |
> > |  Are there any differences between DELETE and DELETE FROM statements?
> > | Can they be used interchangably? For example"
> > |
> > |  delete from mytable where ....;
> > |
> > |  delete mytable where ....;
> > |
> > |
> > |  Thanks in advance.
> > |
> > |  Nick Li
> > |
>
> > What does the documentation says?
>
> >http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statem...
>
> > Regards
> > Michel
>
> Answer is: they are interchangably, you can delete rows with any of it.- Hide quoted text -
>
> - Show quoted text -

Thanks for your help.

Now I can save some typing.

Nick Li Received on Mon Aug 03 2009 - 08:34:53 CDT