oracle - oracle 中::= 和 := 有什么区别？

Question

这是不可能在 google、bing、yahoo 等上搜索的，因为它使用符号。好烦啊!
::=有什么区别和 :=在 oracle 的 pl/sql 中？

Answer 1

我不确定::= 因为我在 Oracle 中没有看到过，但在 wiki 中没有看到过。说 :=

In computer programming languages, the equals sign typically denotes either a boolean operator to test equality of values (e.g. as in Pascal or Eiffel), which is consistent with the symbol's usage in mathematics, or an assignment operator (e.g. as in C-like languages). Languages making the former choice often use a colon-equals (:=) or ≔ to denote their assignment operator. Languages making the latter choice often use a double equals sign (==) to denote their boolean equality operator.

还要检查 here :

The assignment operator in PL/SQL is a colon plus an equal sign (:=). PL/SQL string literals are delimited by single quotes