mirip sih dengan hirarki, cuma diurutnya ada 2 ketergantungan parent dan no
On 4/17/07, indra syafruddin <[EMAIL PROTECTED]> wrote: > > 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]<dedyafriyanto%40gmail.com> > > > > 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] > > > [Non-text portions of this message have been removed]
