Designing a threaded commenting system

select * from my_table
    start with parent = :TOP_ARTICLE
    connect by prior child = parent;