PL/SQLDeveloper encounters an invalid identifier issue

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.