When data is inserted, Oracle considers it as a variable and requires a value.
The reason is that Oracle defines & as a custom variable.SQL> show all
Appinfo is off and set to "SQL * Plus"
Arraysize 15
Autocommit off
Autoprint off
Autorecovery
Oracle set define off, oracledefine
In SQL/Plus, the default value "&" indicates the substitution variable. That is to say, as long as the symbol appears in the command, SQL/Plus requires you to enter the substitution value.This means that you
The default "&" in Sql/plus represents an alternative variable, that is, Sql/plus will ask you to enter an alternate value whenever the symbol appears in the command.This means that you cannot enter a string containing the symbol into the database
1. Define (that is, host variable)The main role of the host variable is to act as an alternative variable, a medium in which the host environment can interact with Oracle . When you define a host variable by define, you must specify the variable
It is generally written in the storage State policy and the beginning and end. This way, you can reduce network data transmission without returning the affected number of rows.
Can be enhancedProgramThis is a bit more efficient.
Example:
Alter
Et define off override variable functionThe default "&" in Sql*plus represents an alternative variable, that is, Sql*plus will ask you to enter an alternate value whenever the symbol appears in the command. This means that you cannot enter a string
In iOS app development, there are three types of view objects that open the virtual keyboard for input, but how to turn off the virtual keyboard without providing an automated method. This needs our own realization. These three types of view objects
We often see a lot of great apps with some very beautiful controls, and the user experience is great. For example, ToggleButton is a very good example, the iOS system below the exquisite ToggleButton now can be implemented under Android, but also
In iOS app development, there are three types of view objects that open the virtual keyboard for input, but how to turn off the virtual keyboard without providing an automated method. This needs our own realization. These three types of view objects
Since register_globals is set to control the PHP variable access range, if it is enabled, it will cause unnecessary security issues, so it is forcibly disabled here. if the webmaster space is not supported, you can use the following methods to make
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.