PL/SQL Developer Create Table Example
How to create a new table in Oracle? To create a new table, we can choose to compose a hand-writing PL/SQL statement which may be… Read More »PL/SQL Developer Create Table Example
out_of_line_constraint
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
How to Resolve ORA-00904 Invalid Identifier
ORA-00904 ORA-00904 means that you used an invalid identifier to be a column name, which is most likely unmatched in name or incorrect syntax. Since… Read More »How to Resolve ORA-00904 Invalid Identifier