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?
Oracle ALTER TABLE ADD Column By Examplesby Ed ChenJuly 20, 2022July 2, 2023ALTER TABLE ADD COLUMN In this post, I'll show you some practical examples of adding a column to table from the simplest to the complicated.… Read More »Oracle ALTER TABLE ADD Column By Examples
How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scaleby Ed ChenMarch 13, 2021July 2, 20236 CommentsORA-01440 ORA-01440 means that you can't decrease the number precision of the column values directly by modifying the definition of the column. Let's see a… Read More »How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale