Category Archives: Oracle

WALKUP TREES or Hierarchy AND INLINE VIEW

WALKUP TREES (Hierarchy) AND INLINE VIEW 

WALKUP TREES
Using hierarchical queries, you can retrieve data based on a natural hierarchical relationship between rows in a table. However, where a hierarchical relationship exists between the rows of a table, a process called tree walking enables the hierarchy to be constructed. Continue reading

JOINS

JOINS

The purpose of a join is to combine the data across tables.

  • A join is actually performed by the where clause which combines the specified rows of tables.
  • If a join involves in more than two tables then oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. Continue reading