Clever Geek Handbook

What's the difference between :: = and: = in oracle?

It cannot be found on google, bing, yahoo, etc. because it uses characters. How annoying!

What's the difference between ::=

and :=

in oracle pl / sql?

+3


source to share


2 answers


I'm not sure about :: = as I haven't seen this in Oracle, but the wiki says: =

In computer programming languages, the equal sign usually denotes either a boolean operator to test for equality of values ​​(for example, as in Pascal or Eiffel), which is consistent with the use of a symbol in mathematics or an assignment operator (for example, as in languages ​​like C). Languages ​​that make the previous choice often use the colon (: =) or ≔ equivalents to denote their assignment operator. Languages ​​making the latter choice often use the double equal sign (==) to denote their boolean equality operator.



Also check here :

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

+6


source


The only place (which I know of) that is used ::=

is in the syntactic description (or any other language for that matter) using the Backsu-Naur Form (BNF). The symbol is part of the BNF descriptive language itself, not part of the described language. There are many tutorials for BNF - have fun! PL/SQL::=



+3


source






More articles:


All Articles