Category Archives: Oracle

VIEWS

VIEWS

  • A view is a database object that is a logical representation of a table. It is delivered from a table but has no storage of its own and often may be used in the same manner as a table.
  • A view takes the output of the query and treats it as a table, therefore a view can be thought of as a stored query or a virtual table. Continue reading

PARTITIONS in Oracle Database

PARTITIONS

  • A single logical table can be split into a number of physically separate pieces based on ranges of key values. Each of the parts of the table is called a partition.
  • A non-partitioned table cannot be partitioned later.

Continue reading