How To Use Oracle Bind Variables

2 Ansichten (letzte 30 Tage)
Kevin Velado
Kevin Velado am 12 Jul. 2016
Bearbeitet: Kevin Velado am 12 Jul. 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

Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by