Oracle is an object-relational database. A relational database is an extremely simple way of thinking about and managing the data used in a business. It is nothing more than a collection of table of data.
Every organization has some information needs. A library keeps list of members, books and fines. A company keeps information about employees, department and the salaries of employees.
A relational database management system such as oracle gives you a way of doing various task in an understandable and reasonably uncomplicated way. Oracle basically done three things:
1). Lets you to put data into it.
2). Keeps the data save in the form or relation.
3). Lets you get the data out and work with it.
A relational database management system (RDBMS) is an information system that presents information as rows contained in a collection of table, each table processing a set of one or more columns.
The various features of RDBMS are:
1). The ability to create multiple relations and enter data into those tables.
2). An interactive query language.
3). Retrieval of information stored in more than one table.
Today, the relational database is at the core of the information system for many organizations.Oracle is one of the powerful RDBMS that provides efficient and effective solution for major
Various feature of oracle:
1). Large database and space management control.
2). Concurrent database user.
3). High transaction processing performance.
4). Industry accepted standards.
5). Manageable security.
6). Database enforced integrity.
7). Client-server environment.
8). Distributed database system.
With the explosion in the use of World Wide Web (WWW) and web browser led oracle to develop tools that would support dynamic displays content on the web. Also with the emergence of Java language which has platform independent, object oriented, distributed and secure environment appealed to software vendor in writing software once and deploying it on a variety of computer hardware and operating system platform.
SQL*Plus is a software product from oracle corporation that allows user to interactively use the SQL commands, produce formatted reports and supports written command procedure to access oracle database.
Through SQP * Plus a user can do the following things:
(1). Enter, edit, store, retrieve and run SQL commands.
(2). Format, perform calculations on, store and print query results in the form of reports.
(3). List column definition of any table.
(4).Access and copy data between SQL database.
(5). Send massages to and accept responses from end users.