ORACLE

The Oracle Corporation was started in 1917 with the name RSI by Larry Ellison and his associates. During the release of version 3, the company changed its name from RSI to ORACLE.

Oracle tools:

Oracle is an integrated package consisting of a number of tools like SQL* plus, oracle forms, Oracle report writer, Oracle graphics. The tools are very user friendly and enable them to create database objects, forms, reports, etc.

Oracle DBA:

The software that compiles and executes the SQL statements issued by a user is called Oracle DBA. It also sends error message to the user if the SQL statements issued by him is unsuccessful.

SQL * Plus:

SQL* Plus has two parts. They are:

• Interactive SQL.
• PL/SQL.

Interactive SQL:

SQL* plus is a language (Structured Query Language) supported by Oracle. Using SQL* plus we can create, edit, and access data structures like table, views, indexes etc. We can also do calculations, generate reports by formatting query results.

PL/SQL:

It is an extension of SQL. A PL/SQL block can contain any number of SQL statements. This provides the users to write programs using SQL statements as we do in the Languages like C, C++ etc.

Oracle Forms:

Oracle form enables us to create screen to enter data. A form consists of blocks, fields and canvasses. Multiple tables can also be accessed over a single form.

Report Writer:

This is the tool used to generate reports using the data stored in tables and views.

Oracle Graphics:

This is the Oracle tool used to represent data tables and views in graphical forms.

Creating a Table in Oracle:

CREATE TABLE   (column 1 data type, column 2 data type, …….);

Delete Command:

DELETE FROM [where];

Update a Table:

UPDATE set column 1 = expression, column 2= expression……where

Drop table Command:

DROP TABLE ;

Select Command:

SELECT column1, column2, …….from  ;