This discussion is archived
2 Replies Latest reply: Nov 4, 2013 12:40 AM by 979801 RSS

Tree view in Oracle forms

979801 Newbie
Currently Being Moderated

Hello experts,

                     I am new in oracle forms and i am using oracle forms 11g with weblogic server 10.3.5 at windows7.I have a problem to make a tree item in oracle forms based on two tables.

I have 2 tables as:

  • TBL_ARTICAL_MSTR
  • ARTICLE_ID
  • ATRTICLE_TYPE
1MAN
2Women
  • TBL_ARTICLE_DTL
ARTICLE_NO

NAME

ARTICLE_ID

1Jeans1
2Skirts2
3T-Shirt1

Now I want a tree view as:

|

|___MAN

|       |______JEANS

|       |______T-Shirt

|

|___WOMEN

        |______Skirts

 

For this I have made a Record group  with a sql query as:

SELECT 1 , level , TBL_ARTICAL_MSTR.ATRTICLE_TYPE,TBL_ARTICLE_DTL.NAME , NULL , to_char( TBL_ARTICLE_DTL.ARTICLE_NO)
FROM TBL_ARTICAL_MSTR LEFT JOIN TBL_ARTICLE_DTL ON TBL_ARTICAL_MSTR.ARTICLE_ID=TBL_ARTICLE_DTL.ARTICLE_ID
CONNECT BY prior TBL_ARTICLE_DTL.ARTICLE_NO = TBL_ARTICAL_MSTR.ARTICLE_ID
START WITH TBL_ARTICAL_MSTR.ARTICLE_ID=1

 

But There is no any output,Please help me to know that how can i solve it.

Thank You

regards

aaditya.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points