RoSQL - Oracle & Mysql Client
Free App
Advertisements
About 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 :)
*** 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 :)
All Application Badges
Free
downl.
downl.
Bug
buster
buster
Android app
App History & Updates
What's Changed
V1.96
- bug fix database charset error on android 4.4 and below
V1.95 and before
- new DB-Connect Dialog
- new background colors
- refresh your sql result
- set different NLS-Settings for your session (oracle)
- checkbox in settings to change locale to US (Connect Error Ora-12705)
V1.96
- bug fix database charset error on android 4.4 and below
V1.95 and before
- new DB-Connect Dialog
- new background colors
- refresh your sql result
- set different NLS-Settings for your session (oracle)
- checkbox in settings to change locale to US (Connect Error Ora-12705)
More downloads RoSQL - Oracle & Mysql Client reached 5 000 - 10 000 downloads
Name changed Name changed! RoSQL for Oracle and MySQL now is known as RoSQL - Oracle & Mysql Client.
Version update RoSQL - Oracle & Mysql Client was updated to version 1.52
More downloads RoSQL - Oracle & Mysql Client reached 1 000 - 5 000 downloads
What are users saying about RoSQL - Oracle & Mysql Client
U
by U####:
by U####:
Kept crashing first when connecting, but author of the app fixed it for my case (database with specific character set). Works perfectly now, nice and easy to use, thanks!
L
by L####:
by L####:
Good for quick sql..
D
by D####:
by D####:
Good application
I
by I####:
by I####:
How to connect with oracla and what is the ip address for connection?message show adapter does not establish the connection.
U
by U####:
by U####:
Pls wat is the password
S
by S####:
by S####:
This app does exactly what I need; run queries on external Oracle database, then save them to csv. Could use a little GUI love... but does the job. Thanks!
U
by U####:
by U####:
A few bugs now and then, but excellent app. Thanks, nicely done!
T
by T####:
by T####:
Facing problem in connection. Please tell me the user I'd and password.
U
by U####:
by U####:
how 2 connect to a database???
Y
by Y####:
by Y####:
it's work.. very good
R
by R####:
by R####:
how 2 connect to a database???
V
by V####:
by V####:
Random and ugly ui icons have no meaning, no description etc. Useless. -- Edit: Start query with the flash symbol, really? Just use the simple 'Play/Run' icon, or type Execute etc. Flash symbol is so meaningless. Also I couldn't find how to commit the transaction.
R
by R####:
by R####:
Best App
R
by R####:
by R####:
Excellent App and works really well ! Lo siento Roblo, tenias razon, disculpas, dio la casualidad que habia un problema con las credenciales, no era problema de la App, fue casualidad que se habian cambiado. He evaluado varias App parecidas y esta con diferencia es la que mas me ha gustado=> loved it 4*
N
by N####:
by N####:
Due to SDU mismatch. 1 star, it doesn't do what I downloaded it for.
N
by N####:
by N####:
Now it showing network adaptor could not established ....n whats a password of this Oracle. ..
U
by U####:
by U####:
Pls let me know how to connect to db
N
by N####:
by N####:
Please let me know how to connect it to a db.
T
by T####:
by T####:
Pls send me d table connection setting with the v8 connection.
N
by N####:
by N####:
Pls send me table connection steps as well and can v create new tables here?
N
by N####:
by N####:
I am not able to connect the data base to application.
S
by S####:
by S####:
Please send the table connection steps
H
by H####:
by H####:
it's work.. very good
by J####:
Well done! if only I had a real keyboard & a bigger screen (oh wait...this is a phone) Request: I'd love the ability to have multiple SQL statements on screen and be able to switch between them, so I wouldn't have to erase and re-type to change what I'm querying. But still a fine app! Thanks!