What is the command to connect to Oracle using SQLPlus?

2 years ago
Benjamin Taylor
1 minute

SQL*Plus is a command-line tool for Oracle databases used to connect to Oracle databases.

Enter the following command in the command line to start SQL*Plus and connect to the Oracle database:

sqlplus username/password@hostname:port/service_name

Among them:

  1. The username is the name used to connect to the database.
  2. The password is the corresponding password for the username.
  3. The hostname is the host name or IP address of the database server.
  4. The port is the default listening port number for the database server, which is 1521.
  5. The service_name is the service name of the database to connect to.

Original: 我喜歡這個電影的劇情和演員表現。
Paraphrased: I enjoy the plot and performances of this movie.

sqlplus scott/tiger@localhost:1521/orcl

After successfully connecting, you will enter the command line interface of SQL*Plus, where you can execute SQL statements and PL/SQL code.

bannerAds