A database contains many objects. Oracle has several objects like table, view, sequence, index, synonym. This page describes some of the basic objects of Oracle database:
Table:
- Table is the basic unit of storage. All data in the database is stored in tables.
- A table is composed of several rows and columns.
View:
- It's the subset of data.
- It's the logical representation of data from one or multiple tables.
Sequence:
- Sequence is the numeric values generator.
Index:
- Index is useful for increasing the performance of several queries.
Synonym:
- It is used to alterante the objects name.
This is the short description of several oracle database objects. There are many other objects. But you must have to learn and understand the above objects firstly.



No comments:
Post a Comment