//*/

Tuesday, 19 January 2016

Oracle Objects

Oracle objects:
Database is collection of below components.
1 Logical design
2 Physical design
3 Instance
We can able to access or modify the logical objects when database up and running mode.
The logical design used to store the data in database.
The logical design contains the Oracle objects.This objects used to hold the data.
This objects are available in database.
example of oracle objects:

  • TABLES
  • SEQUENCES
  • SYNONYMS
  • VIEWS
  • PROCEDURES
  • PACKAGES
  • MATERIALIZED VIEW
  • CLUSTER
  • INDEX
  • TRIGGERS
  • TYPE
Use below query  to find the objects in database.

select OBJECT_TYPE from all_OBJECTS;