What is the difference between := and = in Oracle PL/SQL

plsql oracle11g plsqldeveloper colon-equals
Yue Harriet Huang picture Yue Harriet Huang · Aug 21, 2014 · Viewed 20k times · Source

I want to know in Oracle PL/SQL,

= can be used for Boolean comparison, can it be used for assignment as well?

While is := used for variable initialization, can it be used for assignment too?

Then, so what is the difference between the use of 2?

Thanks!

Answer

Bob Jarvis - Reinstate Monica picture Bob Jarvis - Reinstate Monica · Aug 21, 2014

= is the equality comparison operator, both in PL/SQL and SQL. := is the PL/SQL value assignment operator.

These are analogous to == and = in C-derived languages.

Share and enjoy.

Related questions

How to convert VARCHAR2 to BLOB inside Oracle 11g PL/SQL after ORA-06502

I have a function, that calculates hash value of big string! First of all I wrote a cursor T1_CUT, which can include variable count of SELECT statements, something like: SELECT T1.COL1||T1.COL2||...||T1.COLn FROM T1 WHERE …

Read More
How to use Oracle global temporary table?

I am attempting to use an Oracle global temporary table without physically creating a table in the database. The following code is not working. Can someone please explain the proper way to use global temporary tables? declare global temporary table …

Read More
LISTAGG function with two columns

I have one table like this (report) -------------------------------------------------- | user_id | Department | Position | Record_id | -------------------------------------------------- | 1 | Science | Professor | 1001 | | 1 | Maths | | 1002 | | 1 | History | Teacher | 1003 | | 2 | Science | Professor | 1004 | | 2 | Chemistry | Assistant | 1005 | -------------------------------------------------- I'd like to have the following result --------------------------------------------------------- | user_id | Department+Position | --------------------------------------------------------- | 1 | Science,Professor;…

Read More