- It contain multiple data structure, it can be created during the build stage of DB development.
- DB objects are foundation of any database application, there are many different types of database objects that can be created in the oracle RDBMS following are the important objects that database developer frequently use in oracle.
- Table – Structure that can store data (rows and columns).
- View – It will filter through which you can search a table or we can say in simple as subset of data from one or more table.
- Index – Object designed to speed up search in a table (eg:- It is similar to book INDEX it make easy to search the particular topic).
- Sequence – It used to generate unique number as identifies for new rows, they added to a table.
- Synonyms – Alias name for another object, alternative name for table or view.
- Constraint – Enforce set of rule on table.
- Users – Owner of the database object
- Roles – Set of one or more privileges that can be granted to a user.
- Few other Database objects are
- Cluster
- Context
- DB links
- DB triggers
- Dimensions
- Directories
- Index type
- Object table
- Object view
- Operators
- Packages
- Profile
- Roll back segment
- Tables pace
- Restore point
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon