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