tag:blogger.com,1999:blog-7325550215422085906.post232479016507367656..comments2024-03-28T12:51:00.793+05:30Comments on DATAWAREHOUSE CONCEPTS: Hierarchical Retrieval In ORACLE or Hierarchical QueriesUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7325550215422085906.post-40508423205675963562014-02-19T09:52:26.177+05:302014-02-19T09:52:26.177+05:30One less obvious application of the hierarchical q...One less obvious application of the hierarchical queries is to generate test data for development purposes:<br />CREATE VIEW test_view AS<br />SELECT ROWNUM AS row_id, 'test data ' || ROWNUM AS data<br />FROM dual<br />CONNECT BY ROWNUM <= 100<br /><br />Note also that the "ORDER SIBLINGS BY" clause has been available for use with hierarchical queries since version 10g.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-15291479890157130232014-01-11T12:57:18.525+05:302014-01-11T12:57:18.525+05:30It would be more representative to build a tree wi...It would be more representative to build a tree with different indents like: lpad(' ', (LEVEL - 1) * 2, ' | ') || ename as ename.Anonymousnoreply@blogger.com