إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

Hierarchical Data


لا توجد ردود على هذا الموضوع

#1 tomy3k_bakr

tomy3k_bakr

    عضو نشط

  • الأعضــاء
  • 470 مشاركة

تاريخ المشاركة 22 September 2004 - 06:19 PM

If u have a table that contains Hierarchical data u can get ur Hierarchical Data by:

1- Select Name
From Accounts
Start with ACC_ID = ur_paren_id
Connect by Prior ID = ACC_ID

(This if u have a parent & want his childs)

2- Select Name
From Accounts
Start with ID = ur_child_id
Connect by Prior ID = ACC_ID

(This if u have a child & want his parents)



This is new for me so i thinked anyone of u may need it.

it is great.

:ph34r:
Tamer F. Bakr
Senior Database, Application Server, IBM Domino Administrator
TheGroup For Securities
Doha, Qatar