Question: Can someone help me with my SQL codes. I'm trying to create a table using an oracle database. Here are my codes: DROP TABLE Volunteer;
Can someone help me with my SQL codes. I'm trying to create a table using an oracle database.
Here are my codes:
DROP TABLE Volunteer;
CREATE TABLE Volunteer (VolunteerID char(5) NOT NULL, Name varchar(25), Address varchar(40), City varchar(25), State varchar(20), PostCode varchar(8), PRIMARY KEY(VolunteerID));
INSERT INTO Volunteer VALUES('A005','Jacob Hamilton','Klang','22 Deer Rd','Klang','41050','Selangor');
Whenever I run this it says " ERROR at line 1: ORA-00913: too many values ". I have tried changing my values but still the same problem came up. Can anyone advise me on this. Thanks!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
