Use SQL*Plus tool to connect to a database in Oracle 11g XE

It is not news that the SQL Developer tool is a visual, graphical tool to connect to a database in Oracle. About SQL Developer tool you find information from my post “Oracle XE 11g – Installation SQL Developer and set connection to database”. However, you can also connect to database using SQL*Plus tool. This free tool is a batch query tool. I explain you how run it in console in Windows. Let’s start.

First you have to start your Oracle server. Go to
Start->All Programms->Oracle Database ...->Start Database. Look at the screen below:
The Administrator console appears like that:
Write:
sqlplus
After Enter user-name: write name your database and enter . My database it is one of oracle databases: hr. The Enter password: appears. Write password to a database and enter. If you see SQL> sign, you may work in SQL*Plus command line tool.
The other way to connect is write in one line a user name, password and SID. Look at the screen below: For my hr database, password dorota and after @ sign SID as XE. The XE is Express Edition of Oracle server.
If you would like to stop work with SQL*Plus tool, write exit command and enter it.
Maybe you would like to stop Oracle server. You do it by choose from Windows OS:
Start->All Programms->Oracle Database ...->Stop Database. Look at the screen below:
You see the console window like that:
Close this console window. If the server will be stoped and you will try run SQL*Plus tool, you see this information:
The server must be start to use SQL*Plus.
You can find this tool in this folder:
It is convenient to do the shortcut for it to easy run SQL*Plus in console. If you have running Oracle server you can fast run it. You see window like this below.
You can’t call SQL commands. First you must connect to database and put password. So write connect command and enter it. Write user name and password.  Now you may work on this database.
Documentation about SQL*Plus you find under this link:
https://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm