Answer Happy

Posted: **Fri Jul 08, 2022 6:35 am**

: Welcome Page X Edi Justlee Books Worksheet Query Builder Create Table Toys Toyid Number 10 0 Primary Key D Name V 1 (30.28 KiB) Viewed 30 times

Please help. I do not unerstand why i am getting the error 00904when trying to create a table.Where am I going wrong (ORACLE SQLDEVELOPER)
Welcome Page x EDI JustLee Books Worksheet Query Builder CREATE TABLE TOYS ( ToyID NUMBER (10,0) PRIMARY KEY, D); Name VARCHAR2 (30), Date DATE, Cost NUMBER (5,2), Retail NUMBER (5,2), Discount NUMBER (4,2), Category VARCHAR2 (12) SOL Script Output x | Task completed in 1.588 seconds Error starting at line: 1 in command CREATE TABLE TOYS ( ToyID NUMBER (10,0) PRIMARY KEY, Name VARCHAR2 (30), Date DATE, Cost NUMBER (5,2), Retail NUMBER (5,2), Discount NUMBER (4,2), Category VARCHAR2 (12) ) Error report - ORA-00904: : invalid identifier 00904. 00000 - "s: invalid identifier" *Cause: *Action: 1.58800006 seconds