How To Use Oracle Bind Variables

2 views (last 30 days)
Kevin Velado
Kevin Velado on 12 Jul 2016
Edited: Kevin Velado on 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

Answers (0)

Community Treasure Hunt

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

Start Hunting!