PL/SQL developer encounters an exotic flower invalid identifier problem with a note

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.
The blog:http://blog.csdn.net/huangyanlong/article/details/49897839 of Blue

Some time ago, when attempting to extract data using PL/SQL developer, a ora-00936 error was encountered while executing the script.
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 be been entered without a list of columns or expressions or with an incomplete expre Ssion. This message was also issued in cases where a reserved word was misused, as in SELECT TABLE.
Action:check the statement syntax and specify the missing component.
This error, the general solution is the SQL statement problem, but the view statement is not a problem, and finally locked into the source Description field, as below, try to comment out, there is no problem, some do not know why.

In order to complete this data extraction, I would like to use other means.
The same query, using the Sqlplus method, is as follows:

As you can see, the query statement executed successfully.
To determine whether this is a PL/SQL developer bug, did not have time to fine-grained analysis, the first use of sqlplus execution script.
So the operation is as follows:

20 minutes later, 40 million data insertion was successful.

The essays are written.

Blue Growth Kee Series:

Original works, from "Deep Blue Blog" Blogs

The growth of Blue-chase DBA (1): Rushing to the road and into Shandong

Blue Growth Kee-Chase DBA (2): Install! Installation! A long-lost memory that caused me to re-perceive the DBA

The growth of Blue-Chase DBA (3): antique operation, data import and export become a problem

The growth of blue-chasing the DBA (4): Recalling the youth's sorrow, and then exploring Oracle installation

The growth of Blue-Chase DBA (5): No talking about business, annoying application system

The growth of Blue-Chase DBA (6): Work and life: small skills, great people

The growth of Blue-Chase DBA (7): Basic Command, foundation stone

The growth of Blue-chase DBA (8): Regain SP report, recall Oracle's Statspack experiment

The growth of Blue-Chase DBA (9): National Day, chasing DBA, new plan, new departure

The growth of the Blue-Chase DBA (10): flying knives to defend themselves, not expertise: fiddling with middleware WebSphere

The growth of Blue-chase DBA (11): The ease of coming home, the dizzy wake up

The growth of Blue-chase DBA (12): Seven days seven harvested SQL

The growth of blue-chasing DBAs (13): Coordinating hardware vendors, six stories: what you see and feel "servers, storage, switches ..."

The growth of Blue-chase DBA (14): An unforgettable "cloud" side, starting Hadoop deployment

The growth of Blue-Chase DBA (15): Think FTP is very "simple", who chengxiang twists

The growth of Blue-Chase DBA: The DBA also drank and was 捭阖

The growth of blue-chasing DBAs (17): sharing, or spending, learning to grow in the post-IoE era

The growth of Blue-chase DBA (18): A cluster failure on a small machine, caused by an IP replacement

The growth of Blue-Chase DBA (19): The episode on the road: Touching "frame" and "software system"

The growth of Blue-chase DBA (20): Why, build a library escort

Other chapters:

Soccer and Oracle Series (1): 32 Way Princes soldiers of, Oracle32 Process Alliance Group A bigger picture of the Brazilian Smon process

Soccer and Oracle Series (2): Brazil opener Preview, Oracle architecture Talk

Soccer and Oracle Series (3): Oracle process ranking, World Cup round is about to be fought!

Soccer with Oracle Series (4): From Brazil fiasco in Germany, think of the difference in RAC topology comparison!

Soccer and Oracle Series (5): Fifa14 game The missing DirectX Library is analogous to the RPM package from Oracle!

Soccer and Oracle Series (6): The Asian Cup with the library--Refueling Chinese team

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

PL/SQL developer encounters an exotic flower invalid identifier problem with a note