Welcome Page x EDI JustLee Books Worksheet Query Builder CREATE TABLE TOYS ( ToyID NUMBER (10,0) PRIMARY KEY, D); Name V

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Welcome Page x EDI JustLee Books Worksheet Query Builder CREATE TABLE TOYS ( ToyID NUMBER (10,0) PRIMARY KEY, D); Name V

Post by answerhappygod »

Welcome Page X Edi Justlee Books Worksheet Query Builder Create Table Toys Toyid Number 10 0 Primary Key D Name V 1
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 29 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply