SQL Error: ORA-00933: SQL command not properly ended

by

Semicolon ; on the end of command had caused the same error on me. 

cmd.CommandText = "INSERT INTO U_USERS_TABLE (USERNAME, PASSWORD, FIRSTNAME, LASTNAME) VALUES ("
                + "'" + txtUsername.Text + "',"
                + "'" + txtPassword.Text + "',"
                + "'" + txtFirstname.Text + "',"
                + "'" + txtLastname.Text + "');"; <== Semicolon in "" is the cause.
                                                      Removing it will be fine.

Hope it helps.

More Related Contents:

  1. The most efficient way to UPPER CASE two columns in a single query [closed]
  2. Current date in Oracle Db
  3. Merging two tables in SQL [closed]
  4. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  5. How do I do top 1 in Oracle? [duplicate]
  6. Case insensitive searching in Oracle
  7. How to declare variable and use it in the same Oracle SQL script?
  8. How to find the employee with the second highest salary?
  9. Oracle: What does `(+)` do in a WHERE clause?
  10. Are a CASE statement and a DECODE equivalent?
  11. Concatenate results from a SQL query in Oracle
  12. Select a random sample of results from a query result
  13. SQL error “ORA-01722: invalid number”
  14. Disable all table constraints in Oracle
  15. Get month name from date in Oracle
  16. ORA – 00933 confusion with inner join and “as”
  17. SQL Error: ORA-00942 table or view does not exist
  18. How to count the number of occurrences of a character in an Oracle varchar value?
  19. Comparing with date in Oracle sql
  20. SQL selecting rows by most recent date with two unique columns
  21. How to extract group from regular expression in Oracle?
  22. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  23. How to extract week number in sql
  24. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  25. How to handle optional parameters in SQL query?
  26. Return number from Oracle Select statement after parsing date
  27. How do you interpret a query’s explain plan?
  28. How to call Oracle MD5 hash function?
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment