SQL Statement Hang? Why?
SQL 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?
UPDATE SET
How to Resolve ORA-00001: unique constraint violated
ORA-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 name
ORA-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