PL/SQL Developer Create Table Exampleby Ed ChenMay 8, 2023May 15, 2023How 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
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, 2019April 20, 20234 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