Should Bind Variable be used in not so frequently executed statement?
Hi,I'm new to Oracle DB and the concept of using bind variables.
From what I have read so far, it seems to me bind variables is better
when the value passed to a query gets dynamically changed, like
executing a loop of the same query with different values passed in the
WHERE condition.
My question is:
is it worth using bind variable if the query only gets executed periodically? - the application i'm working on has a GUI which calls some SQL to execute when the user click submit. for example, retrieve and update a user's information. However, only one user's information can be shown in the GUI at a time and only one user's info. can be changed in the GUI at a time. So, in this case, is there any value to change the underlying SQL query to use bind variable?
My question is:
is it worth using bind variable if the query only gets executed periodically? - the application i'm working on has a GUI which calls some SQL to execute when the user click submit. for example, retrieve and update a user's information. However, only one user's information can be shown in the GUI at a time and only one user's info. can be changed in the GUI at a time. So, in this case, is there any value to change the underlying SQL query to use bind variable?
1