Table of Contents generated with DocToc
10g, 11.2.x, 12.1.x, 12.2.x
Automatic encoding conversion, configuration not supported.
Supports all tables with read permission.
We will filter out the system user tables. The tables to be connected should not be under a system user account. System users include "OUTLN", "CTXSYS", "SYSTEM", "RDSADMIN", "DBSNMP", "GSMADMIN_INTERNAL", "XDB", "APPQOSSYS", "SYS", "MDSYS", "OLAPSYS", "ORDDATA", "ORDSYS", "WMSYS", "LBACSYS", "DVSYS", "AUDSYS", "OJVMSYS", "FLOWS_FILES", and users starting with "APEX_".
Only SELECT statements are supported. Supports all SELECT-related features supported by the connected Oracle server. Users need to ensure the syntax conforms to Oracle standards.
Supports direct connection using username and password, does not support Proxy Authentication.
Columns of the following types in Oracle server tables cannot be processed correctly. If you need other fields from this table, you can enter the select statement in the SQL query, excluding that field.