Oracle database objects

Oracle database distinguishes between the objects, Below is the list of Oracle objects. Tables Views Indexes Clusters Synonyms Sequences Procedures Functions Packages Triggers All objects that belong to the same user are said to be this user’s schema. Information about existing objects can be retrieved from dba_objects. It is possible to assign object privileges to […]

Continue reading


How to communicate with your RDBMs

You can communicate RDBMS by structural query language (SQL). The SQL is used for inserting/modifying/deleting & Retrieving data from Database. You can also use SQL for Access controls & Administration. SQL is classified into three categories, those categories are listed below. Data Manipulation Language (DML) Data Manipulation Language (DML) statements are used for managing data […]

Continue reading


What is RDBMS

RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields. RDBMS store the data into collection of tables, which might be related by common fields (database table columns). […]

Continue reading