Updating and Deleting data with one statement

[Kraizax]

Hi, I'm looking to update and delete data from separate tables using only one statement (and without the use of stored procedures). For example;

DELETE a FROM table1 WHERE a = A
UPDATE table2 SET b = null WHERE b = A
DELETE c FROM table 3 WHERE c = A

Is it possible to group these are one statement? (Apologies if this is a trivial question, I am quite new to Oracle).

Thanks for your help.

[QVeen72]

Hi,

Create a StoredProcedure With Parameters.
Write all the Delete/Update/Insert stuff in that SP.
Call the SP passing Appropriate parameters..

Regards
Veena

[amitpatel66]

Hi, I'm looking to update and delete data from separate tables using only one statement (and without the use of stored procedures). For example;

DELETE a FROM table1 WHERE a = A
UPDATE table2 SET b = null WHERE b = A
DELETE c FROM table 3 WHERE c = A

Is it possible to group these are one statement? (Apologies if this is a trivial question, I am quite new to Oracle).

Thanks for your help.

It is possible to update and delete at a same time with one statement in oracle if it is a single table.But you want to perform in multiple tables.
What you can do is place these statements in a file and save it as abc.sql.
Then call abc.sql from sqlplus and commit

[debasisdas]

Hi, I'm looking to update and delete data from separate tables using only one statement (and without the use of stored procedures).

That is not possible in oracle.