Table Of Contents
- Latest Update
- Applications Description
- How to install RoSQL - SQL Client for Oracle, MySQL and MSSQL APK for Android?
- How to install RoSQL - SQL Client for Oracle, MySQL and MSSQL APK for PC (Windows 7/8/10 or MAC)?
- RoSQL - SQL Client for Oracle, MySQL and MSSQL Pros & Cons
- RoSQL - SQL Client for Oracle, MySQL and MSSQL related applications
Latest update [menu]
V2.18/19
- changing permissions for using external storage on android 10 and higher
- use private Storage for storing files if external Storage doesn't work
V2.17 and before
- reload last used sql files at program start
- 'selecting area at cursor' for helping you to select a area where the cursor is currently located (semicolon separated) and immediately executing this area
- switch off confirm leaving resultset
- changing behaviour of executing stored procs
Description [menu]
SQL Worksheet and Query Client for Oracle,MySQL and MSSQL Databases
MSSQL is only implemented for Android 5 and higher, not for Android 4.4.
This app should be used in a secure network like a vpn network or a local secured network, because the traffic isn't encrypted !
Google has changed security settings for Android 10 and higher. on some devices the rights for storage access are no longer sufficient and you cannot store your sql's in the file system. a samsung s9 with android 10 can save files, a Huwawei P30 with android 10 cannot do this.
in V2.19 i use a new compatibility mode from google so it should be possible now to use external storage again (after you have given the app the permission to do this).
there is a additional "quick and dirty" solution for this if a problem with external storage still exists. you can use the checkbox in settings "use private storage for storing files". then it is possible to save your sql's in the private area of this app.but then some features are not working any longer. this is a "flat" area, that means you cannot create any subdirectories. also exporting results to csv (use copy to clipboard / sharing for this) or exporting and importing your configs is not working with this solution. you should only use this, if external storage doesnt work for you.
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/load sql statements in/from 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:
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
you can download still a version for Android 4.4 and lower, but it will no longer be maintained.
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 :)
How to install RoSQL - SQL Client for Oracle, MySQL and MSSQL APK for Android [menu]
Download RoSQL - SQL Client for Oracle, MySQL and MSSQL APK file (com.robro.android.rosql_2252_4717232.apk) from SameAPK.com, then follow these steps:
Update Phone Settings
- Go to your phone Settings page
- Tap Security or Applications (varies with device)
- Check the Unknown Sources box
- Confirm with OK
Go to Downloads
- Open Downloads on your device by going to My Files or Files
- Tap the APK file you downloaded (com.robro.android.rosql_2252_4717232.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
How to install RoSQL - SQL Client for Oracle, MySQL and MSSQL APK on Windows 7/8/10 or MAC PC? [menu]
Download RoSQL - SQL Client for Oracle, MySQL and MSSQL APK file(com.robro.android.rosql_2252_4717232.apk) from SameAPK.com to your PC (ex: /Users/xxx/Downloads/(com.robro.android.rosql_2252_4717232.apk)), then follow these steps:
Using Emulator:
- Download And Install one Emulator Softwares (Ex: Bluestacks, GenyMotion, NoxPlayer)
- Simple install APK on PC by drag and drop file com.robro.android.rosql_2252_4717232.apk on Emulator screen
RoSQL - SQL Client for Oracle, MySQL and MSSQL APK Pros & Cons [menu]
Pros
- This app is safe, it's not require high risk permissions
- Compatible with 32 bit device (most Emulator using 32bit arch CPU)
- Compatible with 64-bit device (some android device and current Bluestacks)
Cons
Everything is good.