O'Reilly logo

Concepts of Database Management System by Shefali Naik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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)’ ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required