How To Use Oracle Bind Variables

2 ビュー (過去 30 日間)
Kevin Velado
Kevin Velado 2016 年 7 月 12 日
編集済み: Kevin Velado 2016 年 7 月 12 日
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 件)

カテゴリ

Help Center および File Exchange で Database Toolbox についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by