question on delete statement

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 20 Jun 2003 16:00:15 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703D0D575@lnewton.leeds.lfs.co.uk>

Hi Fabio,

DELETE FROM table_name
WHERE some_condition;

I don't expect your example statement to actually be accepted in SQLPlus or anything else for that matter. To me it has a sytax error as you did not specify the tablename to delete from. I haven't tested it - as I suspect is the case with you.

Cheers,
Norman.

--

---

Norman Dunbar (at home on Linux)
Oracle_at_mssqlBountifulSolutions.co.uk

(Delete a Microsoft database name to reply - clue, mssql !)

---

-----Original Message-----

From: Fabio [mailto:nonce_at_nulla.it]
Posted At: Friday, June 20, 2003 9:04 AM Posted To: server
Conversation: question on delete statement Subject: question on delete statement

Hi
I'm pretty new on Oracle so I'm sorry if this question was posted before.

How is the behaviour of the DB engine on a complex delete query (I'm working
on 9i)?

If I had a query like

delete (select * from A join B on A.f1=B.f1) C where C.f3 = '???' and C.f4 = 0

which table (A or/and B) will be involved in the delete? How could I know if I'm deleting records from A table or B table or both ?
Is there some syntax to specify the table I want delete records from?

Thanks in advance
Fabio Received on Fri Jun 20 2003 - 10:00:15 CDT