Oracle four ways to Access databases

1, SQL plus--command operation;

The database comes with a command tool that allows you to manipulate the database directly in a DOS window. There are two ways to enter using this tool:

(1), after the installation of the database has an application development, subdirectory has a SQL Plus, directly click Open, you can enter the user name, password to log in to the database to operate.

(2), directly open the Windows DOS window (Win key +r->cmd command enter Enter), enter the SQL Plus command and then enter the user name password can be entered.

2, SQL developer--graphical interface operation;

The database comes with a graphical manipulation tool that enables you to directly manipulate tables in a database without using commands.

Connection: Application development under the database folder in the Program menu bar->sql developer can be entered.

3, PL/SQL developer--third-party graphical interface operation tools;

A third-party tool that provides direct access to the database, with the same functionality as the second, which can be used both as a command or as a tool to manipulate the database directly using the interface.

How to use: Download PL/SQL Developer installation or free installation version directly on the Internet. After the download is installed, directly open the execution file, enter the user name, password can be logged into the interface.

4, dbconsole--browser access mode.

After the database is installed, there are two ways to link the browser to access:

1, in the Program Menu folder can see a database control--"Sid", the direct click can enter the browser login page-Enter the user name, password.

2, open the browser directly, enter HTTP://LOCALHOST:1158/EM Enter the login page-Enter the user name, password.

Summary: The above four ways can be connected to the database, and then the database operation.

Common:

1, all need to use the user name password login.

2, all need to start Oracleservice[sid] service. Note: The SID is the database instance name.

Different points:

1, using the first way and the fourth way can not start the database monitoring service: ORACLE_HOME_TNLISTENER[SID] Service

2, using the second and third way must start the database listening service: ORACLE_HOME_TNLISTENER[SID] Service

3, the fourth way to access the database must start the ORACLEDBCONSOLE[SID] service, the first three ways do not need to start this service.

It is recommended to use the second and third ways to access the database because:

1, the first way to manipulate the database using pure command, not only difficult to operate, but also difficult to maintain after the operation, the advantage is the high efficiency of execution;

2, the fourth use browser access, usually only for the database administrator, as a developer do not care about this piece.

3, the use of the second and third can be very convenient operation and maintenance of data. In contrast, the third version is usually higher than the second version, so use a third if possible. A three-party plug-in can be up to dozens of M.