Oracle Enterprise Manager (OEM) : A GUI tool that allows access, maintenance, and monitoring of multiple databases or services within a single application. If Oracle Enterprise Manager (OEM) is installed, another variation of SQL*Plus, called SQL*Plus Worksheet, is available to the DBA. Here’s the OEM Login dialog box: SQL*Plus Worksheet supports all the commands that standard [...]
SQL*Plus
SQL*Plus
SQL*Plus has been around as long as the Oracle RDBMS itself. It is the most basic tool available for connecting to the database and executing queries against the tables in a database. On Unix systems, it can be run in character-based mode, even on a dumb terminal connected to the Unix system via a serial [...]
