How Oracle Add NOT NULL Constraintby Ed ChenNovember 23, 2019December 10, 2022Add 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 Constraintby Ed ChenNovember 23, 2019November 3, 2022Before 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 Identifierby Ed ChenMarch 12, 2019December 10, 20224 CommentsORA-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