Documentation Index
Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt
Use this file to discover all available pages before exploring further.
Oracle Database Connections
TablePro supports Oracle Database 12c and later via Oracle Call Interface (OCI). This covers Oracle Database instances running on-premises, in Docker, or Oracle Cloud.
Oracle Instant Client must be installed before connecting to Oracle Database. Download it from Oracle’s website and ensure the libraries are accessible. Install Plugin
The Oracle driver is available as a downloadable plugin. When you select Oracle in the connection form, TablePro will prompt you to install it automatically. You can also install it manually:
- Open Settings > Plugins > Browse
- Find Oracle Driver and click Install
- The plugin downloads and loads immediately - no restart needed
Quick Setup
Install Oracle Instant Client
Download Basic package for macOS from Oracle
Create Connection
Click New Connection, select Oracle, enter host/port/username/password/service name, click Create
Connection Settings
| Field | Default | Notes |
|---|
| Host | localhost | |
| Port | 1521 | Listener port |
| Service Name | - | Required. Use service name not SID. Check tnsnames.ora if unclear. |
| Username | - | Requires username/password auth (no OS auth) |
Example Configurations
Local (Oracle XE): host localhost:1521, user system, service XEPDB1
Docker: gvenzl/oracle-xe:21-slim image, same config as local
Remote: Standard host/port/credentials, service name from DBA
Oracle Cloud (ADB): Port 1522, service name format mydb_tp, requires TLS wallet download from Oracle Cloud Console
Connection URL
oracle://user:password@host:1521/service_name
Features
Schema Selection: Each user is a schema. Switch with ⌘K. Shows available schemas and objects.
Table Info: Structure (columns, types, nullability, defaults), indexes (B-tree, bitmap), foreign keys, DDL via DBMS_METADATA.
Query Editor: SQL/PL/SQL support. Pagination uses OFFSET/FETCH syntax:
-- Paginated results
SELECT *
FROM hr.employees
ORDER BY employee_id
OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY;
-- Approximate row count (fast, uses statistics)
SELECT num_rows
FROM all_tables
WHERE owner = 'HR' AND table_name = 'EMPLOYEES';
-- View definition
SELECT text
FROM all_views
WHERE owner = 'HR' AND view_name = 'EMP_DETAILS';
-- List all tables in the current schema
SELECT table_name
FROM user_tables
ORDER BY table_name;
SELECT c.constraint_name FROM all_constraints c WHERE constraint_type = 'R' AND owner = 'HR'
Authentication: Username/password only (no OS auth or wallet). Create user: CREATE USER app_user IDENTIFIED BY "Password1!"; GRANT CREATE SESSION, SELECT ANY TABLE TO app_user;
Auth Compatibility
TablePro authenticates via OracleNIO, a pure-Swift implementation of the Oracle TNS wire protocol (no Oracle Instant Client needed).
dba_users.password_versions | Status |
|---|
12C only (recommended) | ✓ Supported |
11G 12C | ✓ Supported |
10G 11G 12C | ✓ Supported |
10G 11G (legacy migration) | ✓ Supported |
10G only (deprecated) | ✓ Supported, but consider rotation |
| External / Kerberos / LDAP-managed | ✗ Not supported. File an issue. |
password_versions contains only 11G or 12C:
ALTER USER <USER> IDENTIFIED BY <new-secure-password>;
SELECT username, password_versions FROM dba_users WHERE username = '<USER>';
password_versions first.
Column Type Support
| Oracle type | Display |
|---|
| VARCHAR2, NVARCHAR2, CHAR, NCHAR, LONG, CLOB, NCLOB, JSON | Text as stored |
| NUMBER | Exact integer up to Int64 range; decimals up to 17 digits of precision |
| BINARY_FLOAT, BINARY_DOUBLE | Native Swift Float/Double |
| DATE | yyyy-MM-dd |
| TIMESTAMP | ISO-8601 in UTC with fractional seconds |
| TIMESTAMP WITH TIME ZONE | ISO-8601 in the host’s local time zone with explicit offset |
| TIMESTAMP WITH LOCAL TIME ZONE | ISO-8601 in the host’s local time zone with explicit offset |
| INTERVAL DAY TO SECOND | D HH:MM:SS plus fractional seconds when non-zero (up to 9 digits, trailing zeros trimmed) |
| INTERVAL YEAR TO MONTH | Y-MM |
| RAW, LONG RAW, BLOB | Lowercase hex, truncated to 4 KB |
| ROWID | As stored |
| BOOLEAN | true / false |
| BFILE | <bfile> placeholder (locator only) |
<unsupported: type> rather than crashing or corrupting data. Report unsupported types via GitHub Issues.
Troubleshooting
Connection refused: Check listener running (lsnrctl status), verify port 1521 open, if Docker check docker start oracle-xe
Invalid service name: Verify service exists: SELECT value FROM v$parameter WHERE name = 'service_names'; List services: lsnrctl services
Instant Client not found: Download Basic package, extract to /usr/local/oracle/instantclient, set DYLD_LIBRARY_PATH
Limitations: Username/password only, BFILE shows locator metadata only (content fetch via DBMS_LOB not supported), PL/SQL limited to anonymous blocks.