It’s because Toad has some strange behaviour when it comes to semicolons and comments (which you can read more about here) If you run this command, you might be getting an ORA-00911: invalid character in Toad.īut, if you look closely, there’s no special characters in the query!
Your query might look like this: INSERT INTO student (student_id, first_name, last_name) If you’re running Toad, you might be seeing some strange behaviour. To resolve it, you can change your query to remove the special character: SELECT student_id, first_name, last_name If you’re getting this error in a SELECT statement, then it’s also probably because there is a special character where there shouldn’t be.Īn example of a query that causes this error is: SELECT student_id, first_name, last_name ORA-00911 invalid character in Oracle SELECT
You can read my guide on the INSERT statement for more information. Or, enclose it in single quotes so it is treated like a string, if you need the value: INSERT INTO student (student_id, first_name, last_name) To resolve it, change your query to remove the special character: INSERT INTO student (student_id, first_name, last_name)
Added a special character to the VALUES without enclosing it in single quotes.Īn example of a query that would cause this error is: INSERT INTO student (student_id, first_name, last_name). Added a special character to one of the column names. If you’re getting this error when running an INSERT statement, it could be that you have: ORA-00911 invalid character While Inserting Let’s take a look at some examples of where you might get this error, and how to resolve it. To resolve this error, you need to remove the special character from your statement, or enclose it in single quotes. A few symbols (such as $#_) are allowed after the first character. Oracle mentions that identifiers (such as table names) cannot start with any character other than letters or numbers. It could be a special character in the WHERE clause that is not enclosed in single quotes. This error occurred because there was a special character in your SQL statement. For all other contexts, consult the SQL Language Reference Manual. Alternative quotes (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. Identifiers enclosed by doublequotes may contain any character other than a doublequote. $#_ are also allowed after the first character. Identifiers may not start with any ASCII character other than letters and numbers. So, you’ve tried to run an SQL statement, such as INSERT or SELECT, and gotten this error: Are you getting an “ORA-00911 invalid character” error when running an SQL statement? Find out what causes it and how to resolve it in this article.
0 kommentar(er)
