sql statement…..

5 pts.
Tags:
Oracle 11g
SQL Server
SQL statements
Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO "CDAAS"."INFORMATION"   2  VALUES ('MBedfo','Maurice','Bedford','Maurice Bedford','','','02/02/1990','1234','','',''); VALUES ('MBedfo','Maurice','Bedford','Maurice Bedford','','','02/02/1990','1234','','','')         * ERROR at line 2: ORA-01722: invalid number

Software/Hardware used:
CENTOS Linux

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello,
Please write to my email address box: (khalifamorin@yahoo.com)
My name is Morin, a good looking girl.
I
became interested in you after going through your profile today and i wish to
continue relationship with you which if nature will permit we have a
long way to go.
I
have a special reason of contacting you which i will make known to you,
tell you more about myself and also send my pictures to you. I will
like you to get back to me through my email address:
(khalifamorin@yahoo.com)
Morin

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    You are most likely inserting a value of an incorrect type, for one of the colums. We would need to know the columns data types to be able to offer accurate suggestions.
    70,220 pointsBadges:
    report
  • Darryn
    Dependant on your nls parameters, it could be your date value. Try using '02-feb-1990' instead of '02/02/1990'
    765 pointsBadges:
    report
  • Kccrosser
    I strongly suggest always enumerating the column names for the Insert - my guess is that you have the columns out of order, or are missing a column, and thus one of the string values is positionally in a column defined as a numeric data type. Instead, try using:
    INSERT INTO "CDAAS"."INFORMATION"
       (idcol, fname, lname, fullname, col5, col6, datecol, numcol, col9, col10, col11)
    VALUES 
       ('MBedfo','Maurice','Bedford','Maurice Bedford','','','02/02/1990','1234','','','');
    (Put the correct column names in the first line, of course...) If you use this style, mismatches or changes in column orders will not cause problems.
    3,830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following