maksudnya untuk yang struktur datanya seperti hirarki ? kalau iya, mungkin bisa dicoba ini :
*SELECT LEVEL, employee_id, manager_id, first_name, last_name* *FROM more_employees* *START WITH employee_id = 1* *CONNECT BY PRIOR employee_id = manager_id* *ORDER BY LEVEL;* table nya ini : CREATE TABLE more_employees ( employee_id INTEGER CONSTRAINT more_employees_pk PRIMARY KEY, manager_id INTEGER CONSTRAINT more_empl_fk_fk_more_empl REFERENCES more_employees(employee_id), first_name VARCHAR2(10) NOT NULL, last_name VARCHAR2(10) NOT NULL, title VARCHAR2(20), salary NUMBER(6, 0) ); Mohon maaf bila salah pengertian. On 16 Apr 2007 21:14:54 -0700, dedy afriyanto <[EMAIL PROTECTED]> wrote: > > Hallo, > punya masalah nih... > ada yang punya algoritma parent-child gak? syukur2 dlama bahasa PL/SQL > > tujuannya buat memprint childnya seluruhnya.. > > trims > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
