“column not allowed here” error in INSERT statement

by

You’re missing quotes around the first value, it should be

INSERT INTO LOCATION VALUES('PQ95VM', 'HAPPY_STREET', 'FRANCE');

Incidentally, you’d be well-advised to specify the column names explicitly in the INSERT, for reasons of readability, maintainability and robustness, i.e.

INSERT INTO LOCATION (POSTCODE, STREET_NAME, CITY) VALUES ('PQ95VM', 'HAPPY_STREET', 'FRANCE');

More Related Contents:

  1. Best way to do multi-row insert in Oracle?
  2. SQL Error: ORA-01861: literal does not match format string 01861
  3. SQL Query output in VBA is different than in SQL Oracle
  4. I want to find out how much zero come after 1 in SQL
  5. GROUP BY with MAX(DATE) [duplicate]
  6. How to use the ‘as’ keyword to alias a table in Oracle?
  7. What is the string concatenation operator in Oracle?
  8. Using an Alias in a WHERE clause
  9. How can I introduce multiple conditions in LIKE operator?
  10. Is there any boolean type in Oracle databases?
  11. Stored Procedure with optional “WHERE” parameters
  12. subquery in FROM must have an alias
  13. SQL multiple columns in IN clause
  14. Convert Unixtime to Datetime SQL (Oracle)
  15. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  16. Selecting the second row of a table using rownum
  17. sqlplus statement from command line
  18. Does Oracle store trailing zeroes for Number data type?
  19. Oracle Update Query using Join
  20. SQL Command not properly ended?
  21. SQL: getting the max value of one column and the corresponding other columns [duplicate]
  22. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  23. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  24. SQL not recognizing column alias in where clause [duplicate]
  25. When I call PreparedStatement.cancel() in a JDBC application, does it actually kill it in an Oracle database?
  26. How to use Alias in Where clause? [duplicate]
  27. Curious issue with Oracle UNION and ORDER BY
  28. Oracle: function based index selective uniqueness
  29. Is there a nesting limit for correlated subqueries in some versions of Oracle?
  30. Insert into from CTE

Leave a Comment