CODEWITHSUNDEEP
sqloracle-databasesqlplus
agent provocateur
agent provocateur

Reputation: 830

Oracle Query - &&# variables from SQLPlus

I have successfully used &&1, &&2, &&3, etc. in my SQLPlus query, and was wondering if it is possible to use this with any Oracle query, not just through SQLPlus?
What are these "variables" properly called?

Upvotes: 0

Views: 421

Answers (1)

OldProgrammer
OldProgrammer

Reputation: 12179

These are called, Substitution Variables. They are only for sqlplus. See reference documentation If you are referring to "other queries" such as withing PL/SQL, those use bind parameters.

Upvotes: 1

Related Questions