PL/SQLDeveloper遇到一个奇葩无效标识符问题随记_MySQL
前段时间前,在尝试使用PL/SQL Developer抽取数据时,执行脚本时,遇到了一个ora-00936报错。
查询报错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.
这个错误,常规解决思路是SQL语句问题,但是查看语句并没有问题,最后锁定到来源描述字段,如下,尝试注释掉,就没有问题,有些不知道为何。
vcq9vfjQ0KOsyOfPwqO6PGJyIC8+DQo8aW1nIGFsdD0="这里写图片描述" src="http://img.blog.csdn.net/20151118010831539" title="\" />
可以看到,查询语句成功执行了。
判断这是否是PL/SQL Developer的bug呢,没来得及细分析了,先采用sqlplus执行脚本了。
于是操作如下:
20分钟过去了,4千万数据插入成功了。
随笔记之。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



When developing programs using the C++ programming language, we often encounter “identifier not found” errors. This error message usually means that the compiler cannot find the definition of a variable, function, or class. This article will explain the cause of this error and how to fix it. Reasons why the identifier cannot be found First, let us take a look at why the "identifier not found" error occurs. This error report usually has the following reasons: 1.1 The variable, function or class is not defined. This is one of the most common reasons for "identifier not found". if a

The requirements for legal identifiers in C language are: 1. The identifier can only consist of letters (A~Z, a~z), numbers (0~9) and underscores (_); 2. The first character must be a letter or Underscores cannot be numbers; 3. The uppercase and lowercase letters in the identifier are different and represent different meanings; 4. The identifier cannot be a keyword.

In the Go language, identifiers are used to name entities. Grammar rules include starting with a letter or underscore, can contain letters, numbers, or underscores, and cannot be reserved keywords. Semantically, constant identifiers starting with an uppercase letter represent immutable values, variable identifiers starting with a lowercase letter represent mutable values, type identifiers starting with an uppercase letter represent a set of values, and function identifiers starting with a lowercase letter are usually preceded by Func prefix. Understanding these rules and semantics is critical to creating clear, maintainable code.

In JavaScript, identifiers refer to names used by users when programming. They are used to name variables, constants, functions, statement blocks, etc., to establish a relationship between names and uses; identifiers usually consist of letters, numbers, and other characters. constitute. The first character of a legal identifier must be a letter, underscore, or dollar sign; it cannot have the same name as a JavaScript keyword or reserved word.

Identifiers are used for any variable, function, data definition, label, etc. in a program. Before starting any language, you must at least know how to name identifiers. In C language, an identifier is a combination of alphanumeric characters, i.e. it starts with a letter or an underscore, and the remainder is a letter, any number or an underscore. Identifier Naming Rules The rules that must be followed when naming identifiers are as follows - The case of alphabetic characters is important. For example, using "TUTORIAL" for a variable is different from using "tutorial" for a variable, and it is different from using "TutoRial" for a variable. These three variables all refer to different variables. There is no requirement for the length of identifiers. We may have problems with some compilers if the identifier exceeds 31 characters. for

There are three types of C language identifiers: 1. Keywords, which are strings with specific meanings specified by the C language, often also called reserved words; 2. Predefined identifiers, which are identifiers predefined by the system, such as function libraries The function names, macro definitions and type aliases in; 3. User-defined identifiers are identifiers defined by users according to their own needs. They are generally used to name variables, functions, arrays, etc. If the user identifier is the same as a keyword, an error will occur during compilation; if it is the same as a predefined identifier, no error will occur during compilation, but the original meaning of the predefined identifier is lost.

The symbols allowed for identifiers in PHP include letters, numbers, underscores and Chinese characters. Detailed introduction: 1. Letters and numbers. Identifiers can be composed of letters and numbers. They can start with a letter and can be followed by any number of letters, numbers or underscores; 2. Underline. Identifiers can contain underscores, but not underscores. beginning; 3. Chinese characters. Starting from PHP 7.2, Chinese characters are allowed to be used in identifiers. $Chinese variables, function Chinese functions (), etc. are all legal identifiers, etc.

Go identifier naming rules: Identifiers must start with a letter or underscore, are case-sensitive, and avoid using keywords. Best practices include using camelCase notation, avoiding abbreviations, and following consistency. Following these rules can improve the readability, maintainability, and quality of your code, thereby improving the understandability of your code base.
