Introduction to oracle management tools, oracle management tools

Introduction to oracle management tools, oracle management tools

1. SQL * plus is a tool software provided by oracle. It is mainly used to execute SQL statements and pl \ SQL blocks.

How to use:

1) choose Start> program> oracle oradb_home10g> application development> SQL * plus.

2) Enter sqlplusw in the running column.

2. Overview:

Sqlplus is a tool used to operate oracle in dos. Its functions are similar to SQL * plus.

1) Enter sqlplus in the running Column

2. Find the executable file sqlplus.exe,

In the oracle main directory \ ora10g \ bin \ sqlplus.exe, double-click it.

3. Overview:

Pl/SQL developer is a third-party software mainly used for development, testing, and optimization of oracle pl/SQL stored procedures such as triggers. This software is not included in oracle and needs to be installed separately.

4. Enterprise manager console (Enterprise manager)

Oracle 10 Gb is managed through web. The general default port is 5500, and 1158 is also available.

Access url (ensure that the oracle service is started ):

Https: // ip: 1158 (or 5500)/em

Https: // machine name: Port/em