Edit-DB Edit-DB
(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016

10.2. Oracle

Ports
The default port is 1521. To use another port in a database connection, prefix it to the Instance (or System Identifier - SID) setting, separated by a colon, in the login dialog, i.e.
port:instanceName

Connection Identification
Connections from Edit-DB have the signature EditDB s=server-name c=client-ip date&time of connection start. This can be seen in the PROGRAM column of the system View v$session.

Database Sequences
Database Sequences can be selected as an object type and listed in the ususal way. Their current values and increments are displayed.



10.2.1. Oracle Packages and Package Body
10.2.2. Oracle Types and Collections