CODEWITHSUNDEEP
sqloracle-database
Mohammad Liton Hossain
Mohammad Liton Hossain

Reputation: 47

missing comma error while inserting using SQL developer

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)')

Upvotes: 1

Views: 81

Answers (2)

Kazi Mohammad Ali Nur Romel
Kazi Mohammad Ali Nur Romel

Reputation: 15893

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)')

Upvotes: 1

eshirvana
eshirvana

Reputation: 24568

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

seems like it should be wrapped in singlqquote

Upvotes: 1

Related Questions