Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- % 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement