How to connect and work with Oracle database in matlab using App Designer?

Показать описание

In this video it shows how to develop a Matlab App to connect and work with Oracle Database. It runs a simple query to fetch the data from the database and display it in the TextArea widget in the App.

Complete source code and other details of this video are posted in the below link:

However, the main code is copied below also for reference:

function OracleDBButtonPushed(app, event)

connection = database('', ...
'CTXSYS', ...
'CTXSYS', ...
'Vendor', 'Oracle', ...
'URL', ['jdbc:oracle:thin:@(Description =' ...
'(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)' ...
'(PORT=1521)) (CONNECT_DATA=' ...
'(SERVER = DEDICATED)(SERVICE_NAME=XE)))' ]);

query = "SELECT table_name FROM user_tables fetch first 10 rows only";

data = fetch(connection, query);

close(connection);

data = table2array(data);
app.OutputTextArea.Value = data;

end

-