Create Table Non_Game
(
P_Id int Not_Null,
Item_Num Char(4) Not Null,
Description Char(30),
On_Hand Decimal(4,0)
Category Char(3)
Price Decimal(6,2),
))
Drew-Shawn 0 Newbie Poster
rproffitt 2,662 "Nothing to see here." Moderator
Just a guess. Maybe it's the missing or extra comma's?
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
ORA-00907: missing right parenthesis
It's the double closing at the end, should be only one.
JamesCherrill 4,733 Most Valuable Poster Team Colleague Featured Poster
Seems bizarre that an extra R.P. is diagnosed as "missing" :)
rproffitt 2,662 "Nothing to see here." Moderator
JC, my bet is they added a R.P. to fix it. The commas look inconsistent, missing on the 2 lines on ON_Hand and maybe an extra on the last line.
Kinda wish they have formatted it so the lines had numbers.
Error messages from compilers and more have been misleading to hilarious for decades. How many of us have seen this? (all of us!)
rproffitt 2,662 "Nothing to see here." Moderator
I think I should have just pasted this in a code block. Here's what I think would work. Try it?
Create Table Non_Game
(
P_Id int Not_Null,
Item_Num Char(4) Not Null,
Description Char(30),
On_Hand Decimal(4,0),
Category Char(3),
Price Decimal(6,2)
) Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.