Overview of Oracle
- 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)’ ...