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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.