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

Related posts:

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

Related posts: