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

ROLLUP GROUPING CUBE

ROLLUP GROUPING CUBE

These are the enhancements to the group by feature.

USING ROLLUP

  • This will give the salaries in each department in each job category along wih the total salary for individual departments and the total salary of all the departments. Continue reading