Tree Hierarchy

Thread View: borland.public.interbase.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Marilia Thu, 28 Nov 2002 15:48

#11241

Author: Marilia
Date: Thu, 28 Nov 2002 15:48

37 lines
1977 bytes

I have a table called Regions then I need to obtain then region and its
descendants ... my table has teh struct below :
CREATE TABLE regions(
       oid_region           NUMERIC(10) NOT NULL,
       oid_parent              NUMERIC(10),
       description            VARCHAR(50) NOT NULL,
       data_c               TIMESTAMP,
       data_u               TIMESTAMP,
       PRIMARY KEY (oid_region),
);

I need to know how to create a procedure that returns the values , for
example :

Table REGIONS

OID_REGION         OID_PARENT    DESCRIPTION

1                                0                            LATIN AMERICA
2                                1                            BRAZIL
3                                1                            BOLIVIA
4                                2                            SAO PAULO
5                                4                            BARUERI


I want the follow resut :

Brazil
Sao Paulo
Barueri


Could someone help me ?

Thanks so much ...

Marilia de Oliveira

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads