SQL - (Bind|Substitution) (Parameter|Marker|Variable)

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - About

A parameter is placeholder in a prepared statement where value of data is replaced at runtime (ie when the program is running).

It permits to reuse the same statement with different value. See SQL - Prepared Statement

A parameter can be:

  • positional (The values are given by order)
  • or name (The values are given by name)
Advertising

3 - Technology

3.1 - Ansi

3.2 - SQL Server

SELECT *
FROM items
WHERE item = @it;

3.3 - Oracle