Oracle Database - Standard Edition - Version 12.2.0.1 and later: DBCA create database fails with ORA-00901: invalid CREATE command
CREATE ROW TYPE addr_typ ( Street CHARACTER VARYING (25) City CHARACTER VARYING(20) State CHARACTER (2) PostalCode CHARACTER VARYING (9) ) ; CREATE ROW TYPE addr_typ ( * ERROR at line 1: ORA-00901: invalid CREATE command -- You received this message because you are subscribed to the G...
where the command you quote is valid. Oracle has no 'CREATE ROW TYPE' command so the database is reporting, correctly, that the syntax is invalid. You need to remember that the title of the book is "SQL for Dummies", not "SQL*Plus for Dummies". The text should have clearly identified...
Oracle Database - Enterprise Edition - Version 19.10.0.0.0 to 19.10.0.0.0 [Release 19]: create blockchain table fails with ORA-00901: invalid CREATE command