Subject | Hierarchical tree |
---|---|
Author | "Sebasti�o Carlos Santos" |
Post date | 2004-11-11T10:59:48Z |
I have the data in accordance with the structure listed below in a table
SQL> select
CON> id_sys_plataforma,
CON> id_sys_plataforma_pai,
CON> nome_plataforma
CON> from
CON> sys_plataforma
CON> order by
CON> id_sys_plataforma;
ID_SYS_PLATAFORMA ID_SYS_PLATAFORMA_PAI NOME_PLATAFORMA
================= ===================== ================================
1 1 Microsoft Windows
2 1 Microsoft Windows 9x
3 2 Microsoft Windows 95
4 2 Microsoft Windows 98
5 3 Microsoft Windows 95 SE
6 6 Linux
I need to mount the structure, in accordance with the example
- Microsoft Windows
----- Microsoft Windows 9x
--------- Microsoft Windows 95
------------- Microsoft Windows 95 SE
--------- Microsoft Windows 98
- Linux
I anticipate gratefulness for the aid
[Non-text portions of this message have been removed]
SQL> select
CON> id_sys_plataforma,
CON> id_sys_plataforma_pai,
CON> nome_plataforma
CON> from
CON> sys_plataforma
CON> order by
CON> id_sys_plataforma;
ID_SYS_PLATAFORMA ID_SYS_PLATAFORMA_PAI NOME_PLATAFORMA
================= ===================== ================================
1 1 Microsoft Windows
2 1 Microsoft Windows 9x
3 2 Microsoft Windows 95
4 2 Microsoft Windows 98
5 3 Microsoft Windows 95 SE
6 6 Linux
I need to mount the structure, in accordance with the example
- Microsoft Windows
----- Microsoft Windows 9x
--------- Microsoft Windows 95
------------- Microsoft Windows 95 SE
--------- Microsoft Windows 98
- Linux
I anticipate gratefulness for the aid
[Non-text portions of this message have been removed]