Replace all & parameters of a query in Sqldeveloper

Question

I have a query that uses several times the same parameter, in Sqldeveloper, calls Substitution Variable (VS), for example, &empresa.

If I use this VS with the query below:

SELECT
    *
FROM
    pedido
WHERE empresa   = &empresa;

The Sqldeveloper before executing the query, asks what the value of the VA, then inform and it performs the query.

Problem:
If I create a more complex query, using the same VA more than once, Sqldeveloper asks for the VA value every time. I wonder if there is a way to ask only once.

_{P.S.: I don’t want to use another variable to store the value of the VA and then use the variable in several places.}

Answer 1

Using the syntax &variavel, the value assigned to it is temporary, ie will only be used in the current SQL clause.

If you use syntax &&variavel, the value assigned is permanent, that is, the same variable can be used in several SQL clauses.

To documentation can help you.