RelationalDBDesign RelationalDBDesign


Managing Users   «Prev 

Exploring SQLPlus Worksheet

  1. You need to log into a database. Enter system in the Username field and press Tab to advance to the password field.
    Type dogtoad in the Password field and press Tab to advance to the service field.
    Next, tell Enterprise Manager the database to which you want to connect. Type coin in the Service field and click the OK button.
  2. This is the opening screen that you will see after connecting to the database using SQLPlus Worksheet. The CONNECT command, which SQLPlus Worksheet executed for you, is shown in the top half of the window. From here, you can enter and execute any SQL statement you like. Click on the top half of the window to simulate typing a SELECT query.
  3. Click on the lightning-bolt to the left to execute the query.
  4. The query was executed and the results displayed in the bottom half of the screen. The SELECT statement remains in the top half of the screen in case you want to edit it and execute it again. this is the end of the simulation.

SQL*Plus Overview

SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database installation. It has a command-line user interface. There is also the SQL*Plus Instant Client which is a stand-alone command-line interface available on platforms that support the OCI Instant Client. SQL*Plus Instant Client connects to any available Oracle database, but does not require its own Oracle database installation. See the Oracle Call Interface Programmer's Guide for more information on the OCI Instant Client. SQL*Plus has its own commands and environment, and it provides access to the Oracle Database. It enables you to enter and execute SQL, PL/SQL, SQL*Plus and operating system commands to perform the following:
  1. Format, perform calculations on, store, and print from query results
  2. Examine table and object definitions
  3. Develop and run batch scripts
  4. Perform database administration
You can use SQL*Plus to generate reports interactively, to generate reports as batch processes, and to output the results to text file, to screen, or to HTML file for browsing on the Internet. You can generate reports dynamically using the HTML output facility of SQL*Plus.

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. 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.