RoSQL - SQL Client Apk
Apk Infos
| Version | 2.56 |
| Rating | 4.2/5, based on 155 votes |
| Size | 4.5 MB |
| Requires Android | Android |
| Author's Notes | Oracle / MySQL / MSSQL Sql Client / Worksheet for your Database |
About RoSQL - SQL Client APK
Table Of Contents
Description
SQL Worksheet and Query Client for Oracle / MySQL and MSSQL DatabasesIMPORTANT
This app was developed as a private tool for accessing databases from Android devices.
Primarily, the development was designed for Oracle databases.
It is provided free of charge and does not claim to compete with professional tools.
No warranty is provided for any damage that may result from the handling of this app.
The use of this app is at your own risk.
As this app stores its data in the file system and therefore has a file browser function, this app requires access to all directories in the file system.
This functionality offers the possibility to store your SQLs and selected data in any directories and also to import externally created SQLs into the editor of the app in order to be able to perform more complex queries that are difficult to create with an Android app.
My app will not read, change, delete or otherwise use any of your data from the file system in any way without your consent.
On Android 10 and higher my internal Filemanager is now replaced by Standard Android Open and Save File Functions, because Google does not allow "manage all files" to my app. for this i do not need "manage all files" anymore but some features are lost about this change like setting a default directory and such things.
Main Functions of this app:
- 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'
RoSQL should be used in a secure network like a vpn network or a local secured network, because the traffic isn't encrypted !
MSSQL is only implemented for Android 5 and higher, not for Android 4.4.
On Android 11 or higher you have give the app file read and write permissions in your android phone settings. see special app rights on your phone. it seems to be different to set for different phones/android versions.
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.
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
Latest updates
What's new in version 2.56
V2.52- new android requirements minimum target >= 34
- bug fixes
- file management (open/save) changed about google requirements
V2.52 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
How to install RoSQL - SQL Client APK on Android phone or tablet?
Download RoSQL - SQL Client APK file from ApkClean, 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-v2.56-ApkClean.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
Older Versions
| 2.56 (2256) | 4.5 MB |
Questions & Answers
Q: What is an APK File?
A: Just like Windows (PC) systems use an .exe file for installing software, Android does the same. An APK file is the file format used for installing software on the Android operating system.
Q: If I install an APK from this website, will I be able to update the app from the Play Store?
A: Yes, absolutely. The Play Store installs APKs it downloads from Google's servers, and sideloading from a site like ApkClean.net goes through a very similar process, except you're the one performing the downloading and initiating the installation (sideloading).
As soon as the Play Store finds a version of the app newer than the one you've sideloaded, it will commence an update.
Q: Why ApkClean.net can guarantee APK 100% safe?
A: Whenever someone wants to download an APK file from ApkClean.net, we'll check the corresponding APK file on Google Play and allow user download it directly (of course, we'll cache it on our server). If the APK file does not exist on Google Play, we'll search it in our cache.
Q: What are Android App permissions?
A: Apps require access to certain systems within your device. When you install an application, you are notified of all of the permissions required to run that application.
Don't hesitate to contact us if you have any questions or concerns.
(*) is required
