How To Use Oracle Bind Variables
2 views (last 30 days)
Show older comments
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
0 Comments
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!