Question : I ran an update query joining across a huge number of tables that updated one field, and it […]
Tag: dml
How to determine the collation of a table in PostgreSQL?
Question : I want to script a check of the collations used on my tables in PostgreSQL, but googling for […]
Why insert in with is returning unexpected results?
Question : Context Schema setup create table users( id serial primary key ); Query 1 with t1 as ( insert […]
Trigger firing despite no rows being affected
Question : This is more of a general question but the motivation for this question was a problem I faced […]
How to Combine Insert, Update, and Delete in the same `Instead Of` Trigger, in Oracle db?
Question : When creating an Instead Of trigger, Sql Developer allows to include all 3 DML actions in the same […]
Why is a COUNT query faster than a result set query?
Question : Suppose I have two similar queries, with complex joins; query 1 returns rows and columns: SELECT col1, col2, […]
Why is a COUNT query faster than a result set query?
Question : Suppose I have two similar queries, with complex joins; query 1 returns rows and columns: SELECT col1, col2, […]
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings?
Question : I’m seeking a certain string in a field and want to replace it with a new string. Specifically, […]
Using EXECUTE IMMEDIATE inside PLSQL Block
Question : Using EXECUTE IMMEDIATE inside PLSQL block makes the whole block commit immediately. begin INSERT INTO Customer ( GUID, […]
How DML queries execute in MySQL InnoDB [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]