How to use DELETE statement in SQLin Oracle

Tsubasa Yoshikawa

Solved

Question

I'm trying to execute DELETE statement in SQL in Oracle Database.

But it fails to test like below.

Also, I added semicolon at the end of Delete statement like this,

-------------------

DELETE FROM {Detail}

DELETE FROM {Origin};

-------------------

but it didin't work.

Here is my EntityDiagram.

Could you possibly tell me the solution?

Best,

06 Dec 2022

Mostafa Othman

Champion

Solution

Hello Tsubasa,

Try to use following syntax:

begin

delete from {Detail};

delete from {Origin};

end;

06 Dec 2022

Gourav shukla

Hello Tsubasa Yoshikawa,

Thanks

06 Dec 2022

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.