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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!