How To Use Oracle Bind Variables

Kevin Velado

2016 7 12

0 个回答

6 次查看（30 天）

显示更早的评论

0 个投票

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