الانتقال إلى المحتوى
View in the app

A better way to browse. Learn more.

مجموعة مستخدمي أوراكل العربية

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

شجرة النظام ... ما الخطأ في الكود ... موضوع هام للنقاش

Featured Replies

بتاريخ:

بسم الله الرحمن الرحيم
اخواني الاعزاء , انا الانى بصدد انشاء شجرة للنظام الذي اعمل عليه , وقررت انشاء شجرة
لهذا النظام , وقمت بعمل الاتي : -
بدايتا انشاء هذه ال view

create or replace view tree_aa  as
select  'a0' as parint,'b1' as childer,'Preparing System'   as name_ar from dual
union all select  'a0' as parint,'b2' as childer,'Main File System' as name_ar from dual
union all select  'a0' as parint,'b3' as childer,'Report System'  as name_ar
from dual
union all select  'a0' as parint,'b4' as childer,'Help '  as name_ar
from dual
union all select  'b1' as parint,'c1' as childer,'Divisions' as name_ar from dual
union all select  'b1' as parint,'c2' as childer,'Categories' as name_ar from dual
union all select  'b1' as parint,'c3' as childer,'Jobs'as name_ar from dual
union all select  'b1' as parint,'c4' as childer,'Users' as name_ar from dual
union all select  'b1' as parint,'c5' as childer,'Employees' as name_ar from dual
union all select  'b2' as parint,'d1' as childer,'Display Assets' as name_ar from dual
union all select  'b2' as parint,'d2' as childer,'Delete Assets' as name_ar from dual
union all select  'b2' as parint,'d3' as childer,'Request And Replay Assets' as name_ar from du
union all select  'b3' as parint,'e1' as childer,'Divisions' as name_ar from dual
union all select  'b3' as parint,'e2' as childer,'Categories' as name_ar from dual
union all select  'b3' as parint,'e3' as childer,'Jobs' as name_ar from dual
union all select  'b3' as parint,'e4' as childer,'Users' as name_ar from dual
union all select  'b3' as parint,'e5' as childer,'Assets' as name_ar from dual
union all select  'b3' as parint,'e6' as childer,'Delete Assets' as name_ar from dual
union all select  'b3' as parint,'e7' as childer,'Request' as name_ar from dual
/


طبعا ناتج هذه ال view هو :-

 STATE	  LEVEL NAME_AR				   N TO
------- ---------- ------------------------- - --
1		  1 Preparing System			b1
1		  2 Divisions				   c1
1		  2 Categories				  c2
1		  2 Jobs						c3
1		  2 Users					   c4
1		  2 Employees				   c5
1		  1 Main File System			b2
1		  2 Display Assets			  d1
1		  2 Delete Assets			   d2
1		  2 Request And Replay Assets   d3
1		  1 Report System			   b3
STATE	  LEVEL NAME_AR				   N TO
------- ---------- ------------------------- - --
1		  2 Divisions				   e1
1		  2 Categories				  e2
1		  2 Jobs						e3
1		  2 Users					   e4
1		  2 Assets					  e5
1		  2 Delete Assets			   e6
1		  2 Request					 e7
1		  1 Help						b4


وقمت بانشاء شاشة للشجرة , وبصراحة لا اعلم سبب عدم ظهور الداتا على الشجرة وسأقوم
بارفاقها ....
يظهر مسج لي استعلام غير مقبول للشجرة الهرمية frm-473131
ارجوا التكرم بمساعدتي ...

tree2008.zip

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.