Oracle

I’m working on a project which involves hierarchical data that I want to output as an unordered list in HTML. I want to do this in a single SQL statement without resorting to PL/SQL loops. This is partially to post my solution, as well as to solicit ideas from anyone else who has [...]

Link to the original site

Tags: Hierarchical Data, ORACLE BLOGS, Pl Sql, Sql Statement

Related posts

• The Cluster said: "I forbid you to migrate SYSTEM tablespace to local" (0)
• Oracle keeps closing my TAR because I cannot provide a testcase, can you help? (0)
• Improving performance in your ODP.NET application (0)
• Daily Roundup of News, Tips and Tricks for 2010-02-06 (0)
• 4 Useful and Interesting Links for 2009-12-02 (0)
• Why do I have hundreds of child cursors when cursor_sharing set to similar in 10g (0)
• Using Oracle Database 11g Hierarchical Profiler in SQL Developer (0)
• Use DBMS_UTILITY instead of SQLERRM (0)
• Upgrading PHP Web Applications with Minimum Downtime using Oracle Editioning (0)
• UKOUG2008 – Thursday (0)