Create Table SQL Statement
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
Nullable
How Oracle Add NOT NULL Constraint
Add NOT NULL Constraint As I mentioned in resolving ORA-00904 for adding a constraint, NOT NULL is a constraint, but it's more like an attribute… Read More »How Oracle Add NOT NULL Constraint
How Oracle Remove NOT NULL Constraint
Before we talk about how to remove NOT NULL constraint, I assume that you have already know how to add a NOT NULL constraint to… Read More »How Oracle Remove NOT NULL Constraint