plsql_bind_varialbes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
plsql_bind_varialbes [2020/06/04 15:03] – andonovjplsql_bind_varialbes [2020/06/04 15:43] (current) – [Hard Parse] andonovj
Line 50: Line 50:
 Of course, there are database settings, which we can use, to FORCE the optimized to use its magic, but in general using bind varialbes is always better. Of course, there are database settings, which we can use, to FORCE the optimized to use its magic, but in general using bind varialbes is always better.
  
-Here is how this could've have been done using bind varialbes:+Here is how this could've have been done using bind varialbes with Native Dynamic SQL:
  
 <Code:bash|Hard Parse Example with Bind Variables> <Code:bash|Hard Parse Example with Bind Variables>
  • plsql_bind_varialbes.1591283027.txt.gz
  • Last modified: 2020/06/04 15:03
  • by andonovj