How to use SQL*Plus in Oracle Database

This article introduces the knowledge of "how to use SQL*Plus in Oracle database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

How to use SQL*Plus in Oracle database? There are two versions of SQL*Plus: the Windows version and the command line version. You can use the command-line version of SQL*Plus on any operating system running an Oracle database, and then I'll show you how to use SQL*Plus.

1. Start the Windows version of SQL*Plus

If you are using the Windows operating system, click the Start menu and select program/Oracle/Application development/SQL*Plus to start SQL*Plus. As shown in the following figure, enter Scott in Username and tiger in Password (Scott is a sample user included in most Oracle databases). Host String is used to tell SQL*Plus where the database is running. If it is running on your local computer, it will be left blank. If not, you should consult the database administrator. Click ok to continue with other operations. After successfully logging in to the database, you will see the SQL*Plus window through which you can interact with the database.

two。 Start the command line version of SQL*Plus

To start the command-line version of SQL*Plus, you can use the sqlplus command, the full syntax of the sqlplus command is as follows:

Sqlplus [user _ name [/ password [@ host_string]

Where: user_name specifies the user name of the database.

Password specifies the password of the database user.

Host_string specifies the database to connect to.

That's all for "how to use SQL*Plus in Oracle database". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!