I am looking to insert some values into a column based on the selection of a specific row. I have a table with columns a, b, c, and d. I want to insert the values 1, 2, and 3 into columns b, c, and d when column a = X. I cannot find how to do this.
Toad for oracle is my platform and I am looking for SQL code.
You can either update them one at a time:
update mytable set b = 1 where a = X;
update mytable set c = 2 where a = X;
update mytable set d = 3 where a = X;
Or update them all in one go:
update mytable set b = 1,c = 2,d = 3 where a = X;
Alternatively, assuming 'a' is a primary key column or unique index and there is only 1 row where a = X, if you only have 4 columns and you want to update 3 of them you could delete your row and re-insert the whole lot:
delete from mytable where a = X;
insert into mytable values(X, 1, 2, 3);
update mytable set b = 1,c = 2,d = 3 where a = X;
You can use INSERT INTO...SELECT and give condition to your insert queries such as:
INSERT
INTO table_name (b, c, d)
VALUES (bValue, cValue, dValue)
/* Select Condition */
WHERE a=1
