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?
There's no direct way to rename an user, simply because Oracle does not support it. A supported way is to DROP USER then CREATE USER… Read More »How Oracle Rename User
ALTER TABLE RENAME CONSTRAINT To rename a constraint, we need to do it through ALTER TABLE. Let's see a constraint. SQL> show user USER is… Read More »How Oracle Rename Constraint
ALTER TRIGGER RENAME TO To rename a trigger, we can use ALTER TRIGGER RENAME TO statement to rename it. For example: SQL> show user USER… Read More »How Oracle Rename Trigger