How to update and insert data in a single SQL Query .

Question

Possible Duplicate:
Oracle: how to UPSERT (update or insert into a table?)
How to Perform an UPSERT so that I can use both new and old values in update part

I want to know that how a single Query can update and delete data from database .

Please help me with this :)

Update and insert, or update and delete? Your title and question say two different things. — mellamokb, Apr 23 '12 at 18:53

score 1 · Answer 1 · answered Apr 23 '12 at 19:01

1

There is a MERGE command.
It lets you do upserts. Since 10g it also contains a DELETE clause

answered Apr 23 '12 at 19:01

A.B.Cade

16,535
1
36
52

score 0 · Answer 2 · answered Apr 23 '12 at 18:52

0

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...); DELETE FROM table_name
WHERE some_column=some_value

I think

answered Apr 23 '12 at 18:52

Qzen

23
4

score 0 · Answer 3 · edited Jul 22 '12 at 12:23

0

delete from table where id = 1
update table set name = 'john' where id = 1

edited Jul 22 '12 at 12:23

Nikola K.

6,963
13
28
39

answered Apr 23 '12 at 18:53

juergen d

195,137
36
275
343

How to update and insert data in a single SQL Query .

3 Answers3