Home Database Mysql Tutorial PL/SQLDeveloper遇到一个奇葩无效标识符问题随记_MySQL

PL/SQLDeveloper遇到一个奇葩无效标识符问题随记_MySQL

May 30, 2016 pm 05:09 PM
identifier

前段时间前,在尝试使用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千万数据插入成功了。
这里写图片描述

随笔记之。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

C++ error: identifier not found, what should I do? C++ error: identifier not found, what should I do? Aug 22, 2023 am 10:45 AM

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

What are the requirements for legal identifiers in C language? What are the requirements for legal identifiers in C language? Aug 27, 2020 pm 01:47 PM

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.

Understanding Go identifiers: from syntax to semantics Understanding Go identifiers: from syntax to semantics Apr 07, 2024 pm 09:36 PM

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.

What is the meaning of identifiers in javascript What is the meaning of identifiers in javascript Jun 15, 2021 pm 05:41 PM

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.

In C language, what is an identifier? In C language, what is an identifier? Sep 02, 2023 pm 10:09 PM

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

What types of identifiers are there in C language? What types of identifiers are there in C language? Nov 28, 2022 pm 07:03 PM

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.

What are the allowed symbols for identifiers in PHP? What are the allowed symbols for identifiers in PHP? Sep 18, 2023 pm 02:20 PM

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 usage guide: convention practices, optimized code Go identifier usage guide: convention practices, optimized code Apr 07, 2024 pm 01:06 PM

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.

See all articles