How to connect to Oracle db and run SQL queries from matlab command line and database explorer App?

In this video it shows the steps to configure the Oracle database in the matlab environment using the database explorer. The it shows how one run a query on the connected database through the database explorer or Matlab commands/ script.

In this video it initially shows the result of connecting to the database through the Windows command prompt using sqlplus command.

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:

%%
connection = database("Oracle_Local", "CTXSYS", "CTXSYS");

Query = "select table_name from user_tables fetch first 10 rows only";

data = fetch(connection, Query)

-

[HarikrishnaRao]

Thank you. This is definitely helpful. Simple and straight-forward explanation. Nice job!