Developer:
Price: Free
Rankings: 0 
Reviews: 0 Write a Review
Lists: 0 + 0
Points: 0 + 155 (4.2) ¡
Points +1

Description

RoSQL - SQL Client
SQL Worksheet and Query Client for Oracle / MySQL and MSSQL Databases

IMPORTANT
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
more ↓

Screenshots

#1. RoSQL - SQL Client (Android) By: Robro
#2. RoSQL - SQL Client (Android) By: Robro
#3. RoSQL - SQL Client (Android) By: Robro
#4. RoSQL - SQL Client (Android) By: Robro
#5. RoSQL - SQL Client (Android) By: Robro
#6. RoSQL - SQL Client (Android) By: Robro
#7. RoSQL - SQL Client (Android) By: Robro
#8. RoSQL - SQL Client (Android) By: Robro
#9. RoSQL - SQL Client (Android) By: Robro
#10. RoSQL - SQL Client (Android) By: Robro

Video

What's new

  • Version: New
  • Updated:
  • V2.60
    - bug fix wrong window size on android 15 (hidden parts of the screen)
    V2.56 and before
    - new android requirements minimum target >= 34
    - file management (open/save) changed about google requirements
    - 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

Price

  • Today: Free
  • Minimum: Free
  • Maximum: Free
Track prices

Developer

Points

Not found ☹️

Rankings

Not found ☹️

Lists

Not found ☹️

Reviews

Be the first to review 🌟

Additional Information

  • Version: New
  • ID: com.robro.android.rosql
  • Category:
  • OS:
  • Content Rating:
  • Google Play Rating:  (155)
  • Updated:
  • Release Date:

Contacts

RoSQL - SQL ClientRoSQL - SQL Client Short URL: Copied!

You may also like

    • SQL Client
    • Android Apps: Tools  By: Sebastian D.
    • * * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 174 (4.6)   Version: 1.12.2   Connect effortlessly to a variety of SQL database servers or open local database files. The following vendors are supported: Oracle Database Microsoft SQL Server Microsoft Azure SQL ...
        ⥯ 
    • SQL Client - Connect DB Server
    • Android Apps: Tools  By: HarryM
    • * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 0   Version: 3.7.2   Imagine when you outside of your office/home , you may still want to login your MySQL Server/SQL Server and make some simple queries . With this APP , you can do it with your mobile ...
        ⥯ 
    • RemoDB SQL Client MySQL, MsSQL
    • Android Apps: Tools  By: Christian Castaldi
    • * * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 4,586 (4.5)   Version: 5.1.12   RemoDB offers a free SQL client MySQL, Microsoft SQL, PostgreSQL and SAP Sybase AES database servers with a wide range of tools and quick shortcuts. Features -Database bookmarking -SQL
        ⥯ 
    • SQLApp SQL Client MsSQL, MySQL
    • Android Apps: Tools  By: Diego Martinez Salcedo
    • Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 1 + 130 (3.9)   Version: 3.2   SQLApp is a SQL Client that allows you to connect to databases of different engines DBMS (Data Base Management System), and offers the possibility of interaction with their objects, ...
        ⥯ 
    • SQL Database Manager DB-Client
    • Android Apps: Tools  By: CloudBit Ltd.
    • * * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 83 (4.2)   Version: 1.0.14   SQL CodePad: The Ultimate SQL Editor and Database Client Do you want to learn, practice, and master SQL? Do you need a powerful, easy-to-use tool to run and edit SQL queries? Do you ...
        ⥯ 
    • SQL DB Manager
    • Android Apps: Tools  By: REDOQ
    • Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 0   Version: 1.0.6   SQL DB Manager: Simplify Database Management with our SQL DB Manager Welcome to SQL DB Manager, the ultimate solution for managing SQL databases right from your mobile device. With our
        ⥯ 
    • SQL Play — Learn SQL
    • Android Apps: Tools  By: CreativesHi
    • * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 194 (2.6)   Version: 3.0.7   Learning and Practicing SQL couldn't be Easier! Presenting you with a beautiful SQL Runner App for all your devices - SQL Play. Say goodbye to installing heavy software like MySQL or ...
        ⥯ 
    • SQL Editor
    • Android Apps: Tools  By: gesturedevelop
    • * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 556 (2.8)   Version: 1.0.310   SQL Editor is a very simple SQL editor, it can color the syntax nodes : nodes, attributes, properties, events, support autocompletion and search and replace. Opens the default files ...
        ⥯ 
    • SQL Practice Client
    • Android Apps: Tools  By: ITHotShots
    • * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 250 (2.6)   Version: 2.8   Need an intro to sql to learn SQL and become a SELECT query master? Writing and learning query for mysql database becomes easy with the code editor mysql client in sql tutorial ...
        ⥯ 
    • SQL Compiler Offline
    • Android Apps: Tools  By: Saigenix
    • Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 0   Version: 1.0.2   "Welcome to SQL Compiler Offline your ultimate tool for running SQL queries offline on your Android device! Say goodbye to the limitations of needing an internet connection to execute ...
        ⥯ 
    • (Client part only) Xeoma VMS
    • Android Apps: Tools  By: Felenasoft Ltd.
    • Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 134 (3.4)   Version: 25.3.13   The client-only* free video surveillance app that you can use to connect to your remote Xeoma CMS or Xeoma Cloud VSaaS service - for online viewing of cameras and their recordings, and
        ⥯ 
    • SuperVPN Fast VPN Client
    • Android Apps: Tools  By: SuperSoftTech
    • * * Free   
    • Lists: 2 + 3   Rankings: 5 (1)   Reviews: 0
    • Points: 1 + 4,709,506 (4.6)   Version: 3.0.1   SuperVPN, total free VPN Service without any limitation. Easy to use, one click to connect to VPN server. Unlimited bandwidth and unlimited free time. Fast servers across the world. * ...
        ⥯ 
    • tTorrent Lite - Torrent Client
    • Android Apps: Tools  By: tagsoft
    • * Free   
    • Lists: 0 + 1   Rankings: 0   Reviews: 0
    • Points: 0 + 199,571 (4.3)   Version: 1.8.10   tTorrent is simply the best torrent (P2P) downloader client for Android based devices. Download large files like free movies, free music albums, free software programs, free MP3 files ...
        ⥯ 
    • TRAC Client
    • Android Apps: Tools  By: Michiel van Loon
    • * Free   
    • Lists: 0 + 0   Rankings: 0   Reviews: 0
    • Points: 0 + 15 (4.5)   Version: 0.8.4   Client for TRAC (http://trac.edgewall.org) for managing and keeping track of issues. It requires a TRAC implementation that has been extended with the XMLRPC plugin. Current functions:
        ⥯ 

You may also like

Search operators you can use with AppAgg
Add to AppAgg
AppAgg
Start using AppAgg. It’s 100% Free!
Sign Up
Sign In