Search code examples
sqloracleplsqlbind-variables

What does the colon sign ":" do in a SQL query?

What does : stand for in a query?

INSERT INTO MyTable (ID) VALUES (:myId)

How does it fetch the desired value?

Edit: Also what is that sign called? I wanted to search on google, but what's the name for :?

Solution

  • That's called a bind variable in Oracle.

    what's the name for ":"?

    Colon.