SQL Developer : 21.2.1.204 in Windows
I am working on tuning several SQLs.
In order to preserve the SQL_ID in the database, I must not change the SQL text and hence I must use bind variables in SQL Developer.
Some of the SQLs have nearly 100 bind variables to be replaced I have noticed that once I enter the values for bind variables (and click apply), I don't have to re-enter them when I open a new SQL worksheet. That is a relief.
But, when I stop and start SQL developer ( because I shutdown my laptop every day), everything is gone, understandably.
So, I was wondering if there is a way to save an SQL along with the bind variable values for future executions in SQL Developer ?