RoSQL - Oracle & Mysql Client

SQL Worksheet and Query Client for Oracle and MySQL Databases

*** there is a problem (ORA-12705) with NLS (Oracle and thin client) for some countries. if your phone or tablet has a language (for example Cyrillic) , that is not supported, you can try to change the locale in the settings-window to "US" (checkbox for a US default connection). if you are able to connect with these settings you have use american format for date, time and so on, cause the session is then running with american nls settings. it seems to be a oracle express problem, on tests with oracle standard/enterprise databases i do not have this connect errors.***

- create sql statements

- unlimited resultset rows

- size of a resultset is only limited by your memory

- save sql statements in textfiles

- fix columns in a result set

- sort columns in a result set

- use dynamic variables like &input

- automatic save of dynamic variables

- syntax highlight

- sql beautifier

- create explain plans

- export data to csv

- export and copy data to clipboard

- switch autocommit on/off

- manipulation sql's like 'insert' or 'update'

this oracle sql client uses a direct thin v8 connection for Android 4.4 nd lower and a direct thin v11 connection for android 5 and higher to your database !

**** Android 5 User and higher no longer have to set compatibilty mode 8 for Oracle

**** Android 4.4 User and lower have to set compatibility mode 8 (oracle10 and above) as described below.

*************** Android 4.4 and lower: **

for Oracle12c connections please set in sqlnet.ini (Server) SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

for databases equal oracle10g or 11g: SQLNET.ALLOWED_LOGON_VERSION=8

*******************************************

if your db-admin doesn't allow you direct thin connections (v8 or v11) from a Client, this app can't connect to your oracle database !

tested connections: oracle9i, oracle10g, oracle11g, oracle12c, mysql 5.5

please rate this app if you like it and also tell me what you don't like :)</br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br>