Dear friends
Kindly find here below SQL query which is written to get tree structure . But its getting duplicate. Please suggest where I am getting wrong. Actual Records are 7 where as it displays 15 Records.
On the Oracle 12c Form I want to show itemmaster.Item_Code, itemmaster.Item_Name , bom.Parent_itemcode, bom.child_itemcode. .
1 SELECT 1,
2 LEVEL,
3 TO_CHAR(PARENT_ITEMCODE)PARENT_ITEMCODE,
4 NULL,
5 TO_CHAR(CHILD_ITEMCODE)CHILD_ITEMCODE
6 FROM ERP_BOM
7 CONNECT BY PRIOR CHILD_ITEMCODE=PARENT_ITEMCODE
8 START WITH CHILD_ITEMCODE IS NOT NULL
9* ORDER SIBLINGS BY PARENT_ITEMCODE
SQL> /
1 LEVEL PARENT_ITEMCODE N CHILD_ITEMCODE
---------- ---------- -------------------- - --------------------
1 1 EKOLM002 ADH016
1 1 EKOLM002 ADH018
1 1 EKOLM002 EKOPR002
1 2 EKOPR002 INK001
1 2 EKOPR002 PET032
1 1 EKOLM002 POL001
1 1 EKOPR002 INK001
1 1 EKOPR002 PET032
1 1 EKOSL002 EKOLM002
1 2 EKOLM002 ADH016
1 2 EKOLM002 ADH018
1 LEVEL PARENT_ITEMCODE N CHILD_ITEMCODE
---------- ---------- -------------------- - --------------------
1 2 EKOLM002 EKOPR002
1 3 EKOPR002 INK001
1 3 EKOPR002 PET032
1 2 EKOLM002 POL001
15 rows selected.
sanjay