About SQL*Plus

SQL*Plus is the primary command-line interface to your Oracle database. You use SQL*Plus to start up and shut down the database, set database initialization parameters, create and manage users, create and alter database objects (such as tables and indexes), insert and update data, run SQL queries, and more.

red hat Linux administration training courses malaysia

Before you can submit SQL statements and commands, you must connect to the database. With SQL*Plus, you can connect locally or remotely. Connecting locally means connecting to an Oracle database running on the same computer on which you are running SQL*Plus. Connecting remotely means connecting over a network to an Oracle database that is running on a remote computer. Such a database is referred to as a remote database. The SQL*Plus executable on the local computer is provided by a full Oracle Database installation, an Oracle Client installation, or an Instant Client installation.

red hat enterprise Linux rhel training courses malaysia

Connecting to the Database with SQL*Plus

When you connect with SQL*Plus, you are connecting to the Oracle instance.

• About Connecting to the Database with SQL*Plus
  Oracle Database includes the following components: the Oracle Database instance, which is a collection of processes and memory, and a set of disk files that contain user data and system data.

red hat certified specialist in server hardening malaysia

• Step 1: Open a Command Window
  Take the necessary action on your platform to open a window into which you can enter operating system commands.
• Step 2: Set Operating System Environment Variables
  Depending on your platform, you may have to set environment variables before starting SQL*Plus, or at least verify that they are set properly.
• Step 3: Start SQL*Plus
  Start SQL*Plus.
• Step 4: Submit the SQL*Plus CONNECT Command
  Submit the SQL*Plus CONNECT command to initially connect to the Oracle database instance or at any time to reconnect as a different user.

red hat certified specialist in Linux performance tuning malaysia