missing comma error while inserting using SQL developer

Question

I am getting this error while inserting values in a table. I have more than 500 rows to insert. More than 100 rows have been inserted using same method but it gets an error in this line.

INSERT INTO CHICAGO_CRIME_DATA (ID, CASE_NUMBER, DT, BLOCK, IUCR, PRIMARY_TYPE, DESCRIPTION, LOCATION_DESCRIPTION, ARREST, DOMESTIC, BEAT, DISTRICT, WARD, COMMUNITY_AREA_NUMBER, FBICODE, X_COORDINATE, Y_COORDINATE, YEAR, LATITUDE, LONGITUDE, LOCATION) 
VALUES (7646435.0, 'HS451246', '8/7/2010', '023XX W ROSCOE ST', 460.0, 'BATTERY', 'SIMPLE', 'SIDEWALK', 'TRUE', 'FALSE', 1913.0, 19.0, 32.0, 5.0, 08B, 1160352.0, 1922529.0, 2010.0, 41.94312358, -87.68603108, '(41.943123577, -87.686031082)')

08B should be '08B'. Assuming FBICODE is a string column; if not then your data is bad. That is causing that error anyway. (Also '8/7/2010' appears to be going into a date column so you should really use to_date() or a date literal. not a string literal.) — Alex Poole
– Alex Poole, Commented Jun 9, 2021 at 16:50

eshirvana · Accepted Answer · 2021-06-09 16:48:25Z

1

I think the error is raised because of this value "08B" , for FBICODE column,

seems like it should be wrapped in singlqquote

answered Jun 9, 2021 at 16:48

eshirvana

24.7k3 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mohammad Liton Hossain Over a year ago

Thanks. But previous 100 rows were inserted without any error. I have used import table function from sql developer and trying to insert data from a csv file.

eshirvana Over a year ago

@MohammadLitonHossain because last 100 rows didn't have bad data , but this row has

Mohammad Liton Hossain Over a year ago

Thanks everyone. There are some bad data in my data set.

Kazi Mohammad Ali Nur Romel · Accepted Answer · 2021-06-09 16:55:08Z

1

Instead of 08B you need to use '08B'

Corrected Query:

INSERT INTO CHICAGO_CRIME_DATA (ID, CASE_NUMBER, DT, BLOCK, IUCR, PRIMARY_TYPE, DESCRIPTION, LOCATION_DESCRIPTION, ARREST, DOMESTIC, BEAT, DISTRICT, WARD, COMMUNITY_AREA_NUMBER, FBICODE, X_COORDINATE, Y_COORDINATE, YEAR, LATITUDE, LONGITUDE, LOCATION) 
VALUES (7646435.0, 'HS451246', '8/7/2010', '023XX W ROSCOE ST', 460.0, 'BATTERY', 'SIMPLE', 'SIDEWALK', 'TRUE', 'FALSE', 1913.0, 19.0, 32.0, 5.0, '08B', 1160352.0, 1922529.0, 2010.0, 41.94312358, -87.68603108, '(41.943123577, -87.686031082)')

answered Jun 9, 2021 at 16:55

Kazi Mohammad Ali Nur Romel

16.2k2 gold badges17 silver badges29 bronze badges

Collectives™ on Stack Overflow

missing comma error while inserting using SQL developer

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related