SQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88827-02 |
|
Introduction, 2 of 4
You can use the SQL*Plus program in conjunction with the SQL database language and its procedural language extension, PL/SQL. The SQL database language allows you to store and retrieve data in Oracle. PL/SQL allows you to link several SQL commands through procedural logic.
SQL*Plus enables you to execute SQL commands and PL/SQL blocks, and to perform many additional tasks as well. Through SQL*Plus, you can
The following definitions explain concepts central to SQL*Plus:
The SQL*Plus, SQL, and PL/SQL command languages are powerful enough to serve the needs of users with some database experience, yet straightforward enough for new users who are just learning to work with Oracle.
The design of the SQL*Plus command language makes it easy to use. For example, to give a column labelled LAST_NAME in the database the clearer heading "Last Name", you might enter the following command:
COLUMN LAST_NAME HEADING 'Last Name'
Similarly, to list the column definitions for a table called EMPLOYEES, you might enter this command:
DESCRIBE EMPLOYEES
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|