Difference between DELETE and DELETE FROM statement

#1

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

#2

"Ninjali" <nickli2000 (AT) gmail (DOT) com> a écrit dans le message de news:
7c6e2c4e-ef5e-4e6b-8ac6-0d7e69552160...oglegroups.com...

Quote:

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/B...5.htm#i2117787

Regards
Michel

#3

On Aug 3, 2:00*am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

Quote:

"Ninjali" <nickli2... (AT) gmail (DOT) com> a écrit dans le message de news:
7c6e2c4e-ef5e-4e6b-8ac6-0d7e69552... (AT) d23g2000vbm (DOT) 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/B.../b14200/statem...

Regards
Michel

Answer is: they are interchangably, you can delete rows with any of it.

#4

On Aug 3, 12:22*am, kevin <majun... (AT) hotmail (DOT) com> wrote:

Quote:

On Aug 3, 2:00*am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

"Ninjali" <nickli2... (AT) gmail (DOT) com> a écrit dans le message de news:
7c6e2c4e-ef5e-4e6b-8ac6-0d7e69552... (AT) d23g2000vbm (DOT) 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/B.../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

#5

On 3 Aug, 14:34, Ninjali <nickli2... (AT) gmail (DOT) com> wrote:

Quote:

On Aug 3, 12:22*am, kevin <majun... (AT) hotmail (DOT) com> wrote:

Answer is: they are interchangably, you can delete rows with any of it.

Thanks for your help.

Now I can save some typing.

Or you could write standard SQL which is DELETE FROM tbl, not DELETE
tbl.

--
David Portas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Difference between DELETE and DELETE FROM statement

comp.databases.oracle.misc comp.databases.oracle.misc

Difference between DELETE and DELETE FROM statement - 08-02-2009 , 10:48 AM

Re: Difference between DELETE and DELETE FROM statement - 08-02-2009 , 01:00 PM

Re: Difference between DELETE and DELETE FROM statement - 08-02-2009 , 11:22 PM

Re: Difference between DELETE and DELETE FROM statement - 08-03-2009 , 08:34 AM

Re: Difference between DELETE and DELETE FROM statement - 08-04-2009 , 04:08 PM