oracle 中关键字VALUES 和VALUE 两个关键字的区别
发布网友
发布时间:2022-04-22 22:57
我来回答
共1个回答
热心网友
时间:2022-04-13 19:50
用法上基本无差别,但VALUE并不是一个合法的T-SQL关键字
主要是定义上的区别:VALUES为Reserved
Words,VALUE为Keywords
官方文档:
Reserved
words
and
keywordsare
identifiers
that
have
special
meaning
in
PL/SQL.
You
cannot
use
reserved
words
as
ordinary
user-defined
identifiers.
You
can
use
them
as
quoted
user-defined
identifiers,
but
it
is
not
recommended.
For
more
information,
see"QuotedUser-Defined
Identifiers".
You
can
use
keywords
as
ordinary
user-defined
identifiers,but
it
is
not
recommended.
不能使用保留字作为用户定义的变量。但是当加上双引号就可以,但是不推存。
关键字就可以作为用户定义的变量,但是不推存。