RoSQL - Oracle & Mysql Client
**
* 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=8for 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 :)
Category : Tools
Reviews (30)
Rough around the edges perhaps, but two key features make this app best in category. First, you can tell it to forget your user and password. Second, and important for professional use, it supports MySQL local variables. Incredibly, the higher-rated pay-by-subscription app, like the other apps in this category, does not support local variables. Other features good to great. Deserves a better rating. Damned good job by a rookie, showing the pros how it's done.
Well done app, it does what it must, just a little thing , if you can improve the user interface, idk material or something it would be better. The button size and icons can be tricky to understand. Sorry for bad English
I have yet to test this app. I use most of my installed explorer Apps as File Viewers with settings, now if I can use RoSQL (Like Ro in Android lol mann the places... droid) as a default system editor, Ill want a lockscreen app for notifications. I proposed good apps to start this on are ones that can Analyze and Boost Performance, a Caller ID App, a Launcher, Theres also the draw over apps feature, such as storage to sense if the device is powered on or not :) Google Find, Play Protect EXPERT.
First of all thank you very much for this app. Thank you for multiple tabs...now life is even more easy. Request: 'set as default' option in all tabs for queries. So everytime I connect all tabs will be loaded with queries which I use most frequently.
It's a great start. On oracle db, Select * Queries on tables with many column/rows doesn't return results, but same query with where column= returns row. Also cant open a saved file from device. Thanks for creating RoSQL
I try a lot but I am unable to connect network. I thing its supports below 8 version of android.
Another client that does not allow you to format queries with tabs. Hitting tab will jump you out of the editor.
It connects to DB but it doesn't execute a simple query such as "SELECT * FROM table"...
The keyboard doesn't show up. How I can write the IP and the other things?
io error the network adapter could not establish the connection
Very good I can connect oracle server with this app
The only stable and free android sql app that i've found
Thanks for your support!!! I'm connected
Nice and simple
Great sql tools
Connected first time
Xceptually.
0 stars
it works
Can I use this software to learn SQL practice queries for tables like emp dept etc ? As in oracle 10g?
Not worth downloading.
What a very helpful app! Thanks dev
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!
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!
Good application
How to connect with oracla and what is the ip address for connection?message show adapter does not establish the connection.
Pls wat is the password
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!
A few bugs now and then, but excellent app. Thanks, nicely done!
Simple and effective. My only major complaint is that it doesn't seem like it's possible to have multiple distinct queries on one page. Separating them by semicolon or slash is ignored, and everything on the page is executed, which makes most of my existing SQL files pretty much useless. Maybe I'm just missing something? It would also be great to be able to have multiple tabbed edit pages available to switch between.