RoSQL - Oracle, MySQL and MSSQL Client

Everyone
108

SQL Worksheet and Query Client for Oracle,MySQL and MSSQL Databases

Because of Restrictions of Google i had to change the API to 26. There are a lot of changes because of this reason. if you have stored passwords they will be resetted to empty passwords after installing this version.
MSSQL is only implemented for Android 5 and higher, not for Android 4.4.

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). 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
- syntax highlight
- sql beautifier
- create explain plans
- export data to csv
- export and copy data to clipboard
- 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, mssql server 2016

please rate this app if you like it and also tell me what you don't like :)
Read more
Collapse
4.0
108 total
5
4
3
2
1
Loading...

What's New

V2.01
- Numberpicker for textsize and linecount in resultset
V2.0
- added support for MSSQL
- a lot of internal changes because Google expects now API26. stored passwords must be resetted of this reason.
V1.99 and before
- Oracle -> connect to service names with a pre leading # in DB/Instance for example #XE instead of XE
- bug fix database charset error on android 4.4 and below
- checkbox in settings to change locale to US (Connect Error Ora-12705)
Read more
Collapse

Additional Information

Updated
February 14, 2019
Size
Varies with device
Installs
10,000+
Current Version
Varies with device
Requires Android
Varies with device
Content Rating
Everyone
Permissions
Offered By
Robro
©2019 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.