How To Use Oracle Bind Variables

2 visualizaciones (últimos 30 días)
Kevin Velado
Kevin Velado el 12 de Jul. de 2016
Editada: Kevin Velado el 12 de Jul. de 2016
Hi I am trying to find a way to use Oracle Bind Variables in my MATLAB queries. My DBA has recommended using bind variables for repeated sql queries. The issue I'm running into is I am not sure how to create the variable in MATLAB. I can run the following in SQL Developer:
VARIABLE myid NUMBER;
EXEC :myid := 50359138;
SELECT *
FROM EXAMPLE_TABLE
WHERE ID = :myid;
I'm just not sure how to run that in MATLAB.
Note I am using MATLAB 2014b and have access to the Database Toolbox

Respuestas (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by