SQL Worksheet and Query Client for Oracle,MySQL and MSSQL Databases
MSSQL is only implemented for Android 5 and higher, not for Android 4.4.
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.
- 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
- syntax highlight
- sql beautifier
- create explain plans
- export data to csv
- export and copy data to clipboard
- 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
******************************************************
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
please rate this app if you like it and also tell me what you don't like :)
适用于Oracle,MySQL和MSSQL数据库的SQL工作表和查询客户端
MSSQL仅适用于Android 5及更高版本,而不适用于Android 4.4。
在某些国家/地区,NLS(Oracle和瘦客户端)存在问题(ORA-12705)。如果您的手机或平板电脑使用不支持的语言(例如,西里尔文),则可以尝试将设置窗口中的语言环境更改为“美国”(美国默认连接的复选框)。在使用oracle标准/企业数据库的测试中,这似乎是oracle的明确问题,我没有此连接错误。
-创建sql语句
-无限的结果集行
-结果集的大小仅受您的内存限制
-将sql语句保存在文本文件中
-修复结果集中的列
-对结果集中的列进行排序
-使用动态变量,如&input
-语法突出显示
-SQL美化器
-创建解释计划
-将数据导出到CSV
-导出并将数据复制到剪贴板
-操纵sql就像“插入”或“更新”
此oracle sql客户端对Android 4.4及以下版本使用直接瘦v8连接,对于Android 5及以上版本使用直接瘦v11连接到数据库!
-Android 5用户及更高版本不再需要为Oracle设置兼容模式8
-Android 4.4用户及更低版本必须设置兼容模式8(oracle10及更高版本),如下所述。
*************** Android 4.4及更低版本:**************
对于Oracle12c连接,请在sqlnet.ini(服务器)中设置SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
对于等于oracle10g或11g的数据库:SQLNET.ALLOWED_LOGON_VERSION = 8
****************************************************** ****
您仍然可以下载Android 4.4及更低版本的版本,但将不再维护。
如果您的数据库管理员不允许您从客户端直接进行瘦连接(v8或v11),则此应用程序无法连接到oracle数据库!
测试的连接:oracle9i,oracle10g,oracle11g,oracle12c,mysql 5.5,mssql服务器2016
请为这个应用程序评分(如果您喜欢它的话),并告诉我您不喜欢的内容:)