Re: Difference between DELETE and DELETE FROM statement

From: kevin <majunyue_at_hotmail.com>
Date: Sun, 2 Aug 2009 21:22:28 -0700 (PDT)
Message-ID: <82040b81-c929-47c0-8629-2e0a00e1193a_at_d36g2000prb.googlegroups.com>

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. Received on Sun Aug 02 2009 - 23:22:28 CDT