troubleshooting Question

ORA-00947 Not Enough Values

Avatar of Eaddy Barnes
Eaddy BarnesFlag for United States of America asked on
Oracle Database
6 Comments1 Solution3673 ViewsLast Modified:
Hey Dudes,

I have a Table which contains 19 fields. Now i have some values that i want to insert BUT the total number of values equal exactly 13. Now my question is, is there a way that i can still get the values into the necessary fields and for those fields that dont have any values they just gets overlooked?

e.g
First_name
Last_name
Street
Zip_code
State
Home_Phone
Mobile_Phone
Other_phone

Now for instance i have fields 1 - 6 but not 7 and 8. is there a way i can still get to insert the values from 1 - 6 and since i dont have anything for 7 & 8 they get skipped?

Thx

ASKER CERTIFIED SOLUTION
paquicuba

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros