Original works are from the blog of deep blue. You are welcome to repost them. you must specify the source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: http: blogcsdnnethuangyanlongarticledetails49897839 some time ago, before trying to use PLSQL some time ago, when trying to use PL/SQL Developer to extract data, execute the script, encountered an ora-00936 error.
Query error ora-00936
ORA-00936: missing expression tips
Cause: A required part of a clause or expression has been omitted. for example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. this message is also issued in cases where a reserved word is misused, as in select table.
Action: Check the statement syntax and specify the missing component.
The general solution for this error is the SQL statement, but it is no problem to check the statement. Finally, the source description field is locked, as shown in the following figure. if you try to comment it out, there will be no problem. some do not know why.
Vcq9vfjQ0KOsyOfPwqO6PGJyIC8 + DQo8aW1nIGFsdD0 = "here write picture description" src = "http://img.blog.csdn.net/20151118010831539" title = "\"/>
The query statement is successfully executed.
Check whether this is a bug of PL/SQL Developer. if you haven't had time to analyze it, use sqlplus to execute the script first.
The operation is as follows:
20 minutes later, tens of millions of data are successfully inserted.
Notes.