SQL Worksheet and Query Client for Oracle MySQL and MSSQL
Databases
IMPORTANT
This sql client 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.
RoSQL should be used in a secure network like a vpn network or a local secured network because the traffic isn't encrypted !
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'
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.
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.
Since Android 10 and higher my internal Filemanager is now replaced by the 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.
this oracle sql client uses a direct thin v8 connection for Android 4.4 and lower and a direct thin v11 connection for android 5 and higher to your database !
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 10g 11g 12c mysql 5.5 5.6 8.4 mssql server 2016 2019 2022
IMPORTANT
This sql client 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.
RoSQL should be used in a secure network like a vpn network or a local secured network because the traffic isn't encrypted !
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'
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.
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.
Since Android 10 and higher my internal Filemanager is now replaced by the 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.
this oracle sql client uses a direct thin v8 connection for Android 4.4 and lower and a direct thin v11 connection for android 5 and higher to your database !
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 10g 11g 12c mysql 5.5 5.6 8.4 mssql server 2016 2019 2022
Show More >
RoSQL - SQL Client / What's New in vUnknown
V2.87
- bug fixes
V2.86 and before
- mysql - "characterEncoding" setting (default = utf-8)
- mysql - more modern driver for connecting to a db
- fix: unusable back button on android 16
- new simple 'wait message' as a alternative to progressdialog, can be changed in settings
- wrong window size on android 15 (hidden parts of the screen)
- bug fixes
V2.86 and before
- mysql - "characterEncoding" setting (default = utf-8)
- mysql - more modern driver for connecting to a db
- fix: unusable back button on android 16
- new simple 'wait message' as a alternative to progressdialog, can be changed in settings
- wrong window size on android 15 (hidden parts of the screen)
