Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. 1 Oracle SQL Basics
  5. 1.3.7 Substitution Variables

1.3.7 Substitution Variables

Substitution variables are least important in SQL or P/SQL. This is because they have nothing to do with the way SQL is processed by the database server.

When a substitution variable is used in a statement, SQL*Plus requests an input value. The query is then rewritten, with the substitution variable replaced with the input value. The rewritten statement is passed to the database. As a result, the database server knows nothing of the substitution variable. The following example illustrates this by repeating the previous test, this time using substitution variables.

Was this article helpful to you? Yes No

How can we help?