- Connection Properties
- Backup/Restore
- Name Pattern
- Blob/Clob Support
- Mapping/Conversion
- Proxy Settings
Oracle Connection Properties
Full description is here.
Some Important Properties
| Name | Short Description | Default Value |
|---|---|---|
| internal_logon | Specifies the administrative user for authentication such as SYSDBA | null |
| oracle.net.CONNECT_TIMEOUT(ms) | Specifies the timeout when connecting a socket to the database listener | 0 |
| oracle.jdbc.ReadTimeout(ms) | Specifies the timeout while reading from the socket | null |
Backup/Restore
Format is just a simple XML file. Password is encrypted.
Name Pattern
Date and Time format is here.
When export object, you can rename the indexes, constraints(include primary key) by name pattern.
Make sure the length of the name is less than 30 characters. That is the Oracle limit.
${TABLE_NAME} is a placeholder for the table name. '#' is a placeholder for the serial number.
Blob/Clob Support
When export data, import data, or using the Script Executor, you can use check the CLOB/BLOB support. This will slow down the speed. otherwise, the operation will fail when it encounters a CLOB/BLOB column.
Mapping/Conversion
When Importing data from CSV/TSV/Spreadsheet, you can use the mapping feature. If the field type is not capable with the column type. it can be converted. Conversion must be a valid Oracle function. use '?' for the field.
Proxy Settings
SQLife supports configuring proxies for network connections:
- HTTP Proxy: Set the HTTP proxy server address and port.
- HTTPS Proxy: Set the HTTPS proxy server address and port.
- SOCKS Proxy: Configure SOCKS proxy server address and port.
- Non-Proxy Hosts: Specify hosts that bypass the proxy (e.g., localhost, 127.0.0.1).