SQL Statement Hang? Why?by Ed ChenFebruary 6, 2023June 6, 2023SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… Read More »SQL Statement Hang? Why?
How to Resolve ORA-00001: unique constraint violatedby Ed ChenMay 2, 2020June 6, 20238 CommentsORA-00001 There're only two types of DML statement, INSERT and UPDATE, may throw the error, ORA-00001: unique constraint violated. ORA-00001 means that there's a constraint… Read More »How to Resolve ORA-00001: unique constraint violated
How to Resolve ORA-00903: invalid table nameby Ed ChenMarch 28, 2019April 20, 2023ORA-00903 In this post, I will introduce 3 main error patterns about ORA-00903, they are: Create Table Select Table Insert, Update and Delete Table Alter… Read More »How to Resolve ORA-00903: invalid table name