What is the syntax of CREATE TABLE in Oracle? Since the syntax of CREATE TABLE statement can be very flexible and complicated, so using text-based… Read More »Create Table SQL Statement
Referential Integrity To check the referential relationship of a table in details, we have to join some dictionary views, ALL_CONSTRAINTS and ALL_CONS_COLUMNS. For example, we'd… Read More »How to Find References to Table
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 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