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

bind-variables, oracle, plsql, sql

Solution

That's called a bind variable in Oracle.

what's the name for ":"?

Colon.

Problem

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 `:`?

Original source