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?
ALTER TABLE ADD
Oracle ALTER TABLE ADD Column By Examples
ALTER 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 scale
ORA-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