Use bind variables

As we have just mentioned bind variables, let's sharpen this issue. You should use bind variables in SQL and PL/SQL code to help improve performance and scalability of the Oracle database. Bind variables enable the Oracle database to cache and reuse identical SQL statements. The database checks if the query is already parsed in the shared pool, and if so, it can immediately execute the statement. Otherwise, it will need to perform a hard parse of the statement, which is CPU intensive and increases statement execution time.

Note

Using bind variables is also a very good way to be guarded from possible SQL Injection attacks.