Search results
11 lis 2015 · You could use the SQL%ROWCOUNT Oracle variable: UPDATE table1 SET field2 = value2, field3 = value3 WHERE field1 = value1; IF (SQL%ROWCOUNT = 0) THEN INSERT INTO table (field1, field2, field3) VALUES (value1, value2, value3); END IF;
29 kwi 2015 · IF EXISTS (select * from users where username = 'something') THEN. update users set id= 'some' where username = 'something'; ELSE. insert into users (username) values ('something'); END IF; end $$. delimiter ; and call it like this: call select_or_insert();
17 paź 2024 · The MERGE statement in SQL can insert a new record into a table or update the existing record if it already exists. It is supported by databases like Oracle, SQL Server, and PostgreSQL. Let’s look at how we can use the MERGE statement: MERGE INTO Department AS target.
This statement is equivalent to: update people_target t set (t.first_name, t.last_name) = ( select s.first_name, s.last_name from people_source s where s.person_id = t.person_id ) where exists ( select null from people_source s where s.person_id = t.person_id).
5 gru 2019 · I come from using mostly ms sql, but also sybase and mysql. Now I am working in a company where they use oracle, so I am learning a new dialect. I use exists to determine if I need to do an update or insert in ms sql. IF EXISTS(SELECT 'True' FROM TABLE WHERE COLUMN = @ID) BEGIN UPDATE TABLE; END ESLE BEGIN INSERT INTO TABLE; END
19 lip 2022 · update customers_dim cd set ( full_name, update_datetime ) = ( select cs.full_name, systimestamp from customers_stage cs where cs.customer_id = cd.customer_id ) where exists ( select null from customers_stage ce where ce.customer_id = cd.customer_id )
1 lut 2010 · Here's a query to update a table based on a comparison of another table. If record is not found in tableB, it will update the "active" value to "n". If it's found, will set the value to NULL. UPDATE tableA LEFT JOIN tableB ON tableA.id = tableB.id SET active = IF(tableB.id IS NULL, 'n', NULL)"; Hope this helps someone else.
