% Set preferences with setdbprefs.
s.DataReturnFormat = 'cellarray';
s.ErrorHandling = 'store';
s.NullNumberRead = 'NaN';
s.NullNumberWrite = 'NaN';
s.NullStringRead = 'null';
s.NullStringWrite = 'null';
s.JDBCDataSourceFile = 'C:\Users\lakshmiyeswanth\Desktop\grey algos\database_mfiles_20070321\dbcon.mat';
s.UseRegistryForSources = 'yes';
s.TempDirForRegistryOutput = '';
setdbprefs(s)

% Make connection to database.  Note that the password has been omitted.
% Using JDBC driver.
conn = database('test','scott','password','oracle.jdbc.driver.OracleDriver','jdbc:oracle:thin:');

% Read data from database.
e = exec(conn,'SELECT ALL JOB FROM SCOTT.EMP');
e = fetch(e);
close(e)

% Close database connection.
close(conn)