2 Replies Latest reply: Nov 4, 2013 2:40 AM by 979801 RSS

    Tree view in Oracle forms

    979801

      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.