CHAPTER 12

Overview of Oracle

CHAPTER OBJECTIVES
  • Understanding Oracle as a relational database.
  • Knowing commands of Oracle Database 10g Express Edition.
  • Learning how to manage users, roles and privileges.
12.1 ORACLE AS AN RDBMS

Oracle is a relational database management system (RDBMS) which also supports object-oriented features.

It allows creating tables and setting relationships between tables. Users can write stored procedures and functions with the use of PL/SQL. Automatic transaction support is provided by Oracle. It allows developing applications which can run on the internet. Backup and recovery features are available in Oracle.

12.2 LOGGING INTO ORACLE

Oracle provides ‘Oracle Database 10g Express Edition (Oracle Database 10g XE)’ ...

Get Concepts of Database Management System now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.