The Oracle Relational Database Management System (RDBMS) is an industry leading database system designed for mission critical data storage and retrieval. The RDBMS is responsible for accurately storing data and efficiently retrieving that data in response to user queries.
The Oracle Corporation also supplies interface tools to access data stored in an Oracle database. Two of these tools are known as SQL*Plus, a command line interface, and Developer/2000 (now called simply Developer), a collection of forms, reports and graphics interfaces. This technical working paper introduces the features of the SQL*Plus tool and provides a tutorial that demonstrates its salient features.
This is intended for students and database practitioners who require an introduction to SQL, an introduction to working with the Oracle SQL*Plus tool, or both.
The Oracle is one of best database but oracle is only database for creating table using the SQL*Plus. Sql*Plus can be used to create database tables, enter, edit, retrieve and delete data from our database tables. It can be used to perform calculation on stored data, it can be used to create and prints reports, it can be list the description of our tables, copy data from one database to another, send message to end accept replies from the user.
The SQL statement is a simple set of instruction to the oracle server to perform an action. SQL*Plus can be used simply to process SQL statements one at a time, process SQL statements interactively with end users, utilize PL/SQL for procedural processing of SQL statements, list and prints query result, format query result into reports, describe the contents of a given table, and copy data between databases. This statement contains reserved words and has a specific syntax. A partially constructed SQL statement cannot be executed. Oracle returns an error when this is attempted.
SQL is very flexible language that enable you to accomplish your development efforts. SQL enables you to work with large group of data rather then restricting you to single rows of data. Additionally, SQL allows for the result of one query to be the input to another query statement
SQL*Plus is one of the most common ways to communicate interactively with the oracle database. One of the benefits of SQL*Plus is that you can edit or save the SQL commands that are in the SQL buffer.
The SQL buffer is part of memory managed by SQL*Plus that stores one SQL command at a time. A single SQL command remains in the SQL buffer until a new command is issued.